Could not allocate space for object 'dbo.Accounting'.'IX_Accounting_1' in database

[Nurudeen I. Suleiman]

Please can you help with this error message.

 Debug Message (RunQuery) Query cannot be executed [INSERT into [Accounting] (SessionID, StatusType, InputOcts, OutOcts, UserName, NasIPAddr, CallingStationId, CalledStationId, AcctSessTime, NasIdentifier, NasPort, NasPortId, NasPortType, FramedIPAddr, DisconnectCause, InputGigaWord, OutputGigaWord, [TimeStamp], [Amount], [tracid]) values ('80302850', 'Checkpoint', '2483956', '104693502', 'sp463', '10.100.38.2', '2A:FC:44:6E:60:3B', 'QTRS-hotspot', '330', 'Mosque-Router', '2150639696', 'WLAN', 'Wireless', '172.22.3.45', '0', '0', '0', DATEADD(second, -0, GETDATE()), 0, 'B2E144014F812345A76A5F2E46DA95CE')] (C) Could not allocate space for object 'dbo.Accounting'.'IX_Accounting_1' in database 'TekRADIUS' 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.

Nurudeen

[Yasin KAPLAN]

Hi,

When the value of the MAXSIZE parameter of a database limited to a specific value, you can encounter the Primary filegroup is full error. This error also occurs when you are using the SQL Server express edition. The maximum allowed size of the database in SQL Server Express edition is 10GB. When the database tries to grow beyond 10GB, you will encounter the Primary filegroup is full error.

You should consider backing up old accounting records and deleting them.

Best regards,

Yasin KAPLAN