We have a central Select Server (Ver. 8.11.1.64) for our organization. We also have 18 Select Server Gateways pointed to it, each with their own Custom Activation Group on the central server. The central server hardware is a Dell PowerEdge 2850 with two 2.8 GHz Xeon cpus, 2GB RAM, a 36 GB Primary disk (mirrored +spare) and a 36 GB Secondary disk (not mirrored). This server only does the Select Server licensing.
We are getting the following message in the Event Viewer:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
The SS-UsageLogPostingService.log file shows the SQL database as not being saveable to. There is plenty of disk space available on the server (over 20GB available). The limit of the database is 4GB which appears to have been reached. We have only been running this Select Server since 2-5-2009, and it has built up a database of 4GB over the course of 8 months. Apparently, MS SQL Server 2005 Express has a 4GB database limit. MS SQL Server 2005 Express was included with the install of Select Server 8.11.1.64.
As a result, we have noticed that the server is really slow at opening the Select Server Administration Site. Is there a way to compress the database or to Archive the tables as mentioned in the Help? I noticed this version does not have the Archive function from the previous Select Server versions.
Thanks.
Was this a new installation or a upgrade of a previous version of SELECTserver? 4GB seems high for usage from only 10 months. I suspect that the DB has a large amount of unused space in it and it can be shrunk using the DBCC SHRINKFILE command.
http://support.microsoft.com/kb/907511
If you aren't confortable with running the command from the command line you can download and install the Studio Express Managment studio. We don't install it by default due to the increase it would cause in the setup package.
http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en