Sage ACCPAC ERP running of the MS-SQL Express database
Posted by Glen Mund on Mon, Apr 20, 2009 @ 05:05 PM
MS SQL Express has a database size limit of 4GB. Once your database hits this size, processing and posting can no longer happen, an error message of "insufficient disk space" will show up in Accpac, and data corruption is the most common result. If you are getting close to the 4GB limit - you will need to upgrade to MS SQL Standard Edition. Here's how you can check the size of your database, and avoid the problems that running into that roadblock can cause.
On your server, go to Start / Programs / MS SQL Express 2005 / SQL Server Management Studio. Click CONNECT. Once the Management Studio is open, click on Databases and then right click on your database name (for eg. SAMINC or XYZDAT) and click Properties. On the General page which is displayed, under the Database section, you will see a row for Size and row for Space Available. If the size minus space available of your database is nearing 4GB (or 4000MB), please call us ASAP so we can help you migrate to the standard version of MS SQL Server and avoid the problems that running out of space will cause.