Primary File Group Is Full

Question

Primary File Group Is Full

Steven Mann

SSC Enthusiast

Points: 125
More actions
October 14, 2008 at 9:59 am

#194569

I am getting the error Primary File Group Is Full. Why did this fill up instead of growing? I have it set up to auto grow. Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Is the drive full? Is there a max size set for the file?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steven Mann SSC Enthusiast Points: 125 More actions · Answer 2

I figured it out. They were using MSDE on the back end and I went over 2 Gig.

Grant Fritchey SSC Guru Points: 398898 More actions · Answer 3

Or, depending on how you're growing (by percent is the default and the worst choice), you can run out of space before it finishes growing.

Auto-growth is a nice safety valve, but it's best to monitor space closely and grow the databases yourself rather than rely on auto-growth to catch things for you.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning