Description of Error:
An FSError appears on the screen in ESC. When looking at the FSError.log file the following error appears:
Could not allocate space for object 'tablename' in database 'databasename' because the 'PRIMARY' filegroup is full.
Cause of Error:
Your database has reached the maximum allowed capacity for Microsoft SQL Server Express.
Check the file size to see if you are approaching the SQL Server Express size limit. This can be accomplished by following these instructions:
- Open Electronic Service Control on your server computer and sign into your database.
- Make a backup of your database. This is done by going to File → Backup your data and entering a file directory to store your backup in. Be sure to check the "Overwrite existing backup" box and then click the Backup button.
- When the backup has completed, navigate to the directory on your server where the backup file was saved to. Your backup file will appear with the same name as your database and have a ".dat_bak" extension on it.
For example: A database named "Service" will create a backup named "Service.dat_bak".
- Note the size of your backup file, as this is the same size as your database. If the size of the file is not displayed on the screen automatically, you may right-click on the file and select Properties. The screen that appears will provide you with file information, including the size of that file.
If that backup file is at or approaching 10GB in size, you have reached your limit for Microsoft SQL Server Express. At this point you will need to purchase a full version of Microsoft SQL Server. This does not mean you need to start a new database; you may continue with your current database and not lose any data. You will also want to contact your IT professional for assistance with installing Microsoft SQL Server and migrating your data.
While installing a full version of Microsoft SQL Server, there are several settings to take into account so that Electronic Service Control is able to communicate with its database. This article has all of the information you will need to set it up correctly.