Space issuefor Mdf files...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Space issuefor Mdf files...

Space issuefor Mdf files...

Rate Topic

Display Mode

Topic Options

Author

Message

bala2

Posted Tuesday, December 04, 2012 4:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 13, 2013 1:27 AM
Points: 190, Visits: 633

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.

Post #1392356

arunyadav007

Posted Tuesday, December 04, 2012 4:23 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:06 AM
Points: 42, Visits: 285

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....

Post #1392360

sanket kokane

Posted Tuesday, December 04, 2012 4:26 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:13 PM
Points: 323, Visits: 972

what is the the output of the

Use YourDb

sp_helpfile

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1392361

« Prev Topic | Next Topic »

Permissions