Primary File group is full

SQL Allows you to split databases into “file groups”. This functionality is often used by high-end database system to split the database onto different drives. Cyrious Control only uses one (the default) file group.

This error message is that SQL was not able to increase the size of the primary file group and it is now full. This causes lots of problems. You may see this error directly in Control, or you may find this error in the SQL Server Event log after getting different error messages from Control.

High. User is down and can't save anything in the program.

  1. The harddrive the database is stored on is full.
  2. You have hit the maximum database size limit for the version of SQL Server you are running. If the autogrowth of the filegroup of the database takes it past the maximum, you'll see this error. You can try to set this to a lower percentage to buy some time, but eventually they will have to upgrade.
    • For SQL EXPRESS 2005, the maximum database size is 4GB.
    • For MSDE (SQL 2000 Express), the maximum database size is 2GB.
  3. The Database is not set to Auto-Grow in size.
Resolution

Some options to try are as follows:

  1. Make sure Auto-grow is set.
    • Connect to the SQL instance, right click on the database, select Properties, select Files from the menu on the left.
    • Confirm the autogrowth settings of the StoreData.
    • You can try to adjust it to a smaller number. If the database is 3.8 GB for example, a 10% growth number will put it over but a 1% growth number will not immediately cause it to be too large. This buys some time to upgrade.
  2. Try to shrink the database to remove unused space.
    • Right click on the database,select task, shrink, change the Percentage of free space to leave to 1% (or check “Release unused space” on some versions), check “reorganize files before releasing unused space” then hit 'Ok'.
  • Reported : 7/15/2009
  • Version(s): All
  • Fixed in :
You could leave a comment if you were logged in.