Cisco Cisco Unified Contact Center Enterprise 9.0(2) Maintenance Manual
See Also
For general information about developing a backup strategy, including the use of mirrored disks,
refer to Microsoft’s SQL Server System Administrator’s Guide.
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.
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.
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:
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:
dbdiff database1.table@host1 database2.table@host2
For example:
dbdiff cust1_sideA.ICM_Locks@geoxyzlgra cust1_sideB.ICM_Locks@geoxyzlgrb
The batch script diffconfig.bat invokes dbdiff for various tables to automatically compare two
Unified ICM databases. Its syntax is as follows:
Unified ICM databases. Its syntax is as follows:
diffconfig database1 host1 database2 host2
For example:
diffconfig cust1_sideA geoxyzlgra cust1_sideB geoxyzlgrb
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
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
71
Chapter 5: General Administration
Comparing Databases