Database error - the 'PRIMARY' filegroup is full

Products

• IT Management Suite

Issue/Introduction

'PRIMARY' filegroup is full errors appearing in the logs

You may see similar errors to the below

Failed to insert row into table ( INSERT INTO dbo.[Evt_NS_Security_Privilege_Demand] ([_ResourceGuid],[BatchDemandGuid],[UserName],[BatchDemandResult],[PrivilegeGuid],[Time],[PrivilegeName],[UserSid],[_eventTime]) VALUES (N'17e5dc94-049e-41b2-8a8c-a115b51abc13',N'{c964aa9c-fd7b-49ec-a8c5-bbcf33b81b11}',N'DE\am89fr',N'pass',N'{0bed3ae3-9cd1-4edb-b0e1-47cbe34530a3}',N'2010-10-12 11:25:04',N'Manage Data Connector',N'S-1-5-21-220523388-115176313-1801674531-682810',N'2010-10-12 11:25:05.973') ) ( Exception Details: System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.Evt_NS_Security_Privilege_Demand'.'idx_Evt_NS_Security_Privilege_DemandResourceGuid' in database 'DB_Symantec_CMDB_Server_SQL' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup

Cause

The database had eithe reached its maximum size or autogrowth was not enabled

Resolution

You can either set a larger max size for the database or enable autogrowth

Applies To

SMP 7 sp4 >

SQL 2005