Cisco Cisco IP Contact Center Release 4.6.2 Maintenance Manual

Page of 92
The screen display includes the following information:
Instance name
The database configuration
The size and percentage of the combined files
The size of the data and log files
Step 3
When you are finished viewing the database properties, select Close to exit the window.
Viewing Table Properties
ICMDBA also allows you to view the properties of each table in the database.
To view the properties of a table:
Step 1
Select and expand the database to display the tables of a database.
Step 2
Double-click the table you want to view. The Properties window for the table displays.
Step 3
When you are finished viewing the table properties, select Close to exit the window.
Importing/Exporting Data
You can use Import/Export functions to import/export Unified ICM configuation data from one
database to another.
Note: The ICMDBA Import/Export feature pertains to Unified ICM configuration data only.
To import or export Unified ICM historical data, us Microsoft’s SQL Server Database Backup
and Database Restore utilities.
To import/export data:
Step 1
For the server, instance, and node (Administration & Data Server or Logger), select the database
from which you want to import/export data.
Step 2
Select Data > Import (or Export) from the menu bar. The Import (or Export) window displays.
Step 3
Check Lockout Changes, if you want to ensure that changes cannot be made to the database
during the import or export operation.
Step 4
Check Truncate Config Message Log, if you want to truncate the Config_Message_Log table
in the Logger database.
Note: Truncating deletes the data and does not export the Config_Message_Log table.
Administration Guide for Cisco Unified ICM/Contact Center Enterprise & Hosted Release 8.x
54
Chapter 4: Database Administration
Database Administration Tool