How to drop and rebuild the prairieFyre database once SQL Express...

Expand / Collapse
 

How to drop and rebuild the prairieFyre database once SQL Express has reached its 10 GB limit


Article ID: 50258 - Last Review: February 16, 2017

INTRODUCTION

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



SUMMARY

SQL Express, unlike full SQL, has a database limit of 10 GB.  Once a database in SQL Express has reached 10 GB 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.

NOTE:  It may be more time efficient to try our Data Purge Tool first before dropping and rebuilding the database.



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

For a video tutorial see here
  1. Launch SQL Server Management Studio
  2. Connect to the local instance of SQLExpress
  3. Expand Databases to see CCMData
  4. Right-click CCMData and select Tasks then Detach
  5. Add check-mark to Drop Database and Close Existing Connections
  6. Right-click CCMStatisticalData and select Tasks then Detach
  7. Add check-mark to Drop Database and Close Existing Connections
  8. Click OK

    Browse to the database storage directory (Defaulted to <Install Dir>\Program Files\PrairieFyre Software inc\CCM\Database\ and move the CCMData.mdf, CCMData.ldf, CCMStatisticalData.mdf, and CCMStatisticalData.ldf files into another directory for safe keeping.

Re-create a New Database

  1. Run Contact Center Management Configuration Wizard (MiCC Setup > Repair in versions 8.x)
  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); the database has just been reset, so you will need to log in with the default username and password listed in the User Guide
  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

MiCC/CA/BR


KEYWORDS

SQL drop database



Rate this Article:
     
Tags:

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Thursday, February 16, 2017
Last Modified By: dfountaine
Type: HOWTO
Rated 4 stars based on 1 vote
Article has been viewed 19,365 times.
Options