If your company uses Microsoft’s free version of SQL Server (SQL Express), you must monitor your database sizes to ensure they do not approach the 10 GB limit that Microsoft allows. If your database is approaching this limit, you will need to purchase and install one of the full versions of SQL Server from Microsoft in order to avoid severe system issues that will occur when you reach that limit. This would be handled by your IT department and your Microsoft software vendor.
To check which version of SQL Server you are using, open SQL Server Management Studio and right-click on the server name then select “Properties”.
You will be shown the version in the “Product” field.
If you are using an Express version of SQL server, you will need to check the size of your database. To do this, right-click on the database name and navigate to Reports -> Standard Reports -> Disk Usage.
On the report that is generated, look at the “Data Files Space Usage” section and note the size. The maximum size allowed for Express is 10 GB (10,000 MB). It is recommended that if you are using over 9 GB, you should be preparing to upgrade to a paid version of Microsoft SQL Server.