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

Created by Cheng Kah Poh, Modified on Thu, 12 Oct, 2023 at 3:10 PM by Cheng Kah Poh

Why there is an error message prompted whenever I try to save a new transaction?



Error Message Details :

'System.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object 'dbo.SalesInvoiceDetails'.'PK_SalesInvoiceDetails' in database 'SHSH' 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.


Reason:

Your pc’s hard disk storage is full or your Database size limit is full.


Solution


1) Please try Shrink Database : here


2) Try Purge Audit Trail : here


3) Upgrade your SQL server if you are using SQL Server 2005 Express edition and SQL Server 2008 express edition for another extra 6GB size limit or you can purchase SQL Runtime Server which offer unlimited size limit.

Note: Your database max size is defined by your SQL Server version.


Microsoft SQL Server 2005 Express edition has a database size limit of 4GB
Microsoft SQL Server 2008 Express edition has a database size limit of 4GB
Microsoft SQL Server 2008 R2 Express edition has a database size limit of 10GB
Microsoft SQL Server 2012 Express edition has a database size limit of 10GB
Microsoft SQL Server 2014 Express edition has a database size limit of 10GB



** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article