December 4, 2012 at 4:18 am
Hi,
We have a sql server 2005 server running on win 2003,
Our data files are present on F-drive .
For one of the Database due to space issue we add a another secondary file to another drive and placed
Pryimary data file in-----restricted state( in F-driver)
Secondary file added in D-drive-------autogrowth enable and placed in unrestriced state.
As we have created the secondary file for that database .Now the data should go to secondary file once the primary file reached its max size.BUt we are geeting error as
"primary filegroup is full" for that database and data is not going into seconadry file...
Please suggest.
Many thanks.
December 4, 2012 at 4:23 am
Hello,
Make sure the second data file belongs to 'PRIMARY' filegroup.
And then you can also try shrinking the 1st mdf file using the option 'Empty file by migrating data to other files in the same filegroup.
Regards....
December 4, 2012 at 4:26 am
what is the the output of the
Use YourDb
sp_helpfile
-----------------------------------------------------------------------------
संकेत कोकणे
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply