Maintenance Manual

5-13
Cisco ICM Enterprise Edition Administrator Guide Release 6.0(0)
Chapter 5 General Administration
Comparing Databases
For general information about developing a backup strategy, including the use of
mirrored disks, see Microsoft’s SQL Server System Administrator’s Guide.
For specific information about backing up a database using SQL Administrator,
see Microsoft’s SQL Administrator User’s Guide.
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:
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 ICM databases. Its syntax is as follows:
diffconfig database1 host1 database2 host2
For example:
diffconfig cust1_sideA geoxyzlgra cust1_sideB geoxyzlgrb
Resynchronizing Databases
It may occasionally be necessary to repair a corrupt Logger database on one side
of a duplexed ICM by copying the Logger database from the other side. You can
synchronize the databases using either the DOS Command window or the ICM
Database Administration (ICMDBA) tool.