Problem

By default, GlobalSearch and GlobalCapture are shipping with Microsoft SQL Server Express Edition, Microsoft's free version of SQL Server.  While SQL Express may be enough GlobalSearch versions 5.0.0.0 and higher as well as GlobalCapture versions 2.2 and higher are shipped without Microsoft SQL Server and some users may opt to utilize Microsoft SQL Server Express. While this may be sufficient for most users, there are some limitations that you should be aware of.   In addition to limiting the number of CPUs that can be used, SQL Express limits the amount of RAM that can be consumed by the SQL engine as well as limiting the individual database size to a maximum capacity.   Please see the chart below for information regarding the limitations of SQL Express.

Please note that GlobalSearch versions lower than 5.0.0.0 and GlobalCapture versions lower than 2.2 were shipped with Microsoft SQL Server Express :by default.

Once the database has reached the limit, SQL Server will no longer allow any data to be stored in that database which will prevent Square 9 software from working properly.

...

Purchasing Microsoft SQL Standard is the quickest and most painless way to recover from a database that has reached its maximum capacity.  Microsoft SQL Server Standard edition will remove all limitations on database size (up to 524 PB) as well as raising raise the maximum resources that may be consumed by the SQL Engine.  To purchase Microsoft SQL Server please visit https://www.microsoft.com/en-us/sql-server/

...

Microsoft SQL Server has a build built-in command that allows the database size to be compressed.  If you have old data within your database, purging this data and then performing the shrink commands will allow you to continue using your existing database without making any additional configuration changes.  If you have old data that you no longer need, delete it and then have a qualified IT Professional perform commands on the databases.  To find out more about database shrinking please see Microsoft's article on how to Shrink a Database

Related articles

...