INTRODUCTION

This article describes the steps to drop and rebuild the database once SQL Express has reached its size limit of 4 GB

SUMMARY

SQL Express, unlike full SQL, has a database limit of 4GB.  Once a database in SQL Express has reached 4GB in size, no further data can be written into it.  At this time customers will encounter problems logging into the CCM website and are unable to run reports.  Follow the steps below to drop the existing database to create a new one.

INSTRUCTIONS

Create a backup of the .xml database

1. Launch Contact Center Client (CCC)
2. Click on Management in the top left corner
3. Select Configuration
4. Select Backup/Restore configuration data
5. Select Back up and save .xml file to Desktop
   

Drop the Existing Database

1. Install SQL Server Management Studio Express
   
   PrairieFyre ships this application with the full install.  It is located in the source directory here:
   <Install Dir>\CCM\src\Support\SQL Server Management Studio Express
2. Launch SQL Server Management Studio Express from Start=>All Programs=>Microsoft SQL Server 2005
3. Connect to SQLExpress
4. Expand Databases to see CCMData
5. Right-click CCMData and select Tasks then Detach
   
6. Add check-mark to Drop Database and Close Existing Connections
   
7. Click OK
8. Browse to the database storage directory (Defaulted to <Install Dir>\Program Files\PrairieFyre Software inc\CCM\Database\ and move the CCMData.mdf, and CCMData.ldf files into another directory for safe keeping. (If you've dropped the CCMStatisticalData database as well, move the CCMStatisitcalData.mdf and CCMStatisticalData.ldf files as well)
   

Re-create a New Database

1. Re-run Configuration Wizard from Start=>All Programs=>Mitel=>Contact Center Management Configuration Wizard
2. Click Next and let the Wizard run though
3. The Wizard will re-create a blank new CCMData database
4. Re-launch Contact Center Client (CCC)
5. Click on Management in the top left corner
6. Select Configuration
7. Select Back up/Restore configuration data
8. Select Restore and browse to .xml file on Desktop
   

Re-Summarize Recent Historical Data Back Into SQL

1. Launch Contact Center Client (CCC)
2. Click on Management in the top left corner
3. Select Maintenance
4. Select Summarize Data
5. Under Data Range specify the range for which historical reports are needed
6. Click Next

APPLIES TO

CCM/CA version 5.x