Had anyone of you ever wonder how big your database or account book is?
Do you know that AutoCount is currently using Microsoft SQL Server Express version which is free but has a limitation on its file size?
Here, we will guide and show you how can you check on your database size so that you can take some precautions before you hit the database free size limit offered by Microsoft SQL Server.
To check on your database file size, you will need to your server PC and look for the folder which stored AutoCount data. The default path is usually C:\AutoCount Data or D:\AutoCount Data. In that folder, you can find your account book database name, kindly look for the one which had the wording DATA behind the file name. This is the file that you can look into it to see how big is your database size.
The file size limit for Microsoft SQL Server 2005 will be 4GB (4,000,000 KB), while MIcrosoft SQL Server 2008 and above will be 10GB (10,000,000 KB). So you can check your current version of Microsoft SQL at your server
Control Panel –> Program and Features. (For Windows XP will be Control Panel –> Add and Remove Program)
By knowing the database file size, you can make preparation if it is almost reaching the maximum file size limit offered. What you can do is:
1. If you’re using Microsoft SQL Server 2005, you can upgrade it to 2008 version to enjoy up to 10 GB.
2. Perform Shrink Database.
3. Perform Year End Closing. You will need to perform step 2 after year end closing for best storage clearance.
4. Purchase Microsoft SQL Run Time License. With this license, the Microsoft SQL Server will have no limitation on data file size and able to fully utilize the memory (RAM) which is available at your server PC – which means better performance.