Cisco Cisco IP Contact Center Release 4.6.1 Maintenance Manual

For general information about developing a backup strategy, including the use of mirrored disks,
refer to Microsoft’s SQL Server System Administrator’s Guide.

For specific information about backing up a database using SQL Administrator, refer to
Microsoft’s SQL Administrator User’s Guide.

Best Practices for Performing a Backup

To backup an Unified ICM database:

•

Stop Unified ICM services for the processes that are using the database being backed up.

•

Run the backup.

•

Restart Unified ICM services after the backup completes.

Note: On a duplexed system, calls will continue to be processed if sideA is backed up at a
different time than sideB.

Comparing Databases

For diagnostic purposes, you might want to check that two databases have the same data in a
specific table. For example, you might want to check that the ICM_Locks table contains the
same data on both sides of a Central Controller. The tool dbdiff.exe performs this type of check.
Its syntax is as follows:

For example:

The batch script diffconfig.bat invokes dbdiff for various tables to automatically compare two
Unified ICM databases. Its syntax is as follows:

For example:

Resynchronizing Databases

It might occasionally be necessary to repair a corrupt Logger database on one side of a duplexed
Unified ICM by copying the Logger database from the other side. You can synchronize the

Administration Guide for Cisco Unified ICM/Contact Center Enterprise & Hosted Release 8.x