I get a "Filegroup is full" error when attempting to run an SQL query

When attempting to run an SQL query, an error similar to the following is returned:

Could not allocate space for object 'xxxxx' in database 'DB_xxxxx' because the 'PRIMARY' filegroup is full. The statement has been terminated.

This error indicates that your database size has exceeded the allocated amount. To resolve the problem use the SQL Database Shrink tool to shrink the database (SQL 2008 | SQL 2005).

If you continue to experience the error, you must increase your available SQL space.

Article ID: 117, Created: 1/19/2010 at 12:26 PM, Modified: 5/28/2014 at 12:17 PM

I get a "Filegroup is full" error when attempting to run an SQL query

I get a "Filegroup is full" error when attempting to run an SQL query

Was this article helpful?

Share this article