Could not allocate space for object in database because the 'PRIMARY' filegroup is full

Symptom

The following error appears during Database Setup, usually when upgrading an existing OnGuard installation, on a computer running SQL Server 2005 Express:

"Could not allocate space for object <object_name> in database '<database_name>' because the 'PRIMARY' filegroup is full."

Note: <object_name> represents the name of the database object and <database_name> represents the name of the database containing the object (by default AccessControl).

Resolution

This error occurrs when the OnGuard database exceeds the 4GB size limitation enforced by SQL Server 2005 Express.

To work around this limitation, perform one or more of the following steps:

1) In System Administration, perform an archive or purge of unneeded events, user transactions, etc.

2) To reduce the size of the database, type the following command in a query window in SQL Server Management Studio Express, then press F5 to execute the query. Replace <database_name> with the name of the OnGuard database.

DBCC SHRINKDATABASE ('<database_name>')

3) If steps 1 and/or 2 do not reduce the size of your database to 4GB or less, you may need to obtain the full version of SQL Server 2005. The full version does not have the 4GB size limitation.

Applies To

SQL Server 2005 Express

Additional Information

None