Database error - the 'PRIMARY' filegroup is full
search cancel

Database error - the 'PRIMARY' filegroup is full


Article ID: 152844


Updated On:


IT Management Suite


'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


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


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

Applies To

SMP 7 sp4 >

SQL 2005