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
Feedback sent
We appreciate your effort and will try to fix the article