SQLExpress – What to do when the database is near full




If SQL Express is used in the CCM/IQ environment, it imposes a 4gb capacity (or 10gb for SQLExpress 2008 R2) to each database. After a certain period of time, the database will fill up to its maximum. The amount of time until the maximum capacity is reach depends on the amount of the site traffic / amount of data collected or the amount of historical data present in the database.

When the maximum has been reached, you may experience different symptoms ; it could be an alarm in the Contact Center Client or the data will simply will not be filled in the Database.

We currently have a purging tool that will help remove the unnecessary data from our databases.

The Purger tool checks the CCMData and CCMStatisticalData databases for the oldest data and displays the size.  It then provides you this information with the option of deleting all historical data up to a specified date.  The Purger will delete historical data, which is consuming disk space, then it will shrink the database down.

This tool does not delete any configuration data, only old historical data used for reporting purposes.  If you want to put the data back into SQL after running the tool, just re-summarize using the Contact Center Client.




Leave a Reply

Your email address will not be published. Required fields are marked *