SQL Error: Primary filegroup is full

85 pts.
Tags:
SQL Server
SQL Server error messages
SQL Server performance
SQL Server performance tuning
Hi, I'm getting an error primary filegroup is full. create a space by deleting unneeded files,dropping objects in the filegroup. I have disk space 30gb, then also the error. Please help
ASKED: April 21, 2009  3:44 PM
UPDATED: June 14, 2013  3:19 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Is the data file set to unrestricted growth ? (on your database properties->files check the ‘Autogrowth’ values)

————————-

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Yesu
    no idea about that i am using whatsup gold (network monitoring software) in that it has size limit of 4 gb
    85 pointsBadges:
    report
  • carlosdl
    Are you able to increase that limit ? Also, in Sql Server (not in the monitoring software), you should set the data file to enable autogrowth.
    65,110 pointsBadges:
    report
  • Denny Cherry
    If the database is full, and it can't grow any more beyond the 4 Gig limit you'll get the file/disk full message.
    65,490 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following