Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Guida Dell'Amministratore
10-13
Cisco Customer Response Solutions Administration Guide, Release 6.0(1)
Chapter 10 Managing Cisco CRS Historical Reporting
Truncating Database Transaction Log Files
The Unified WIM/Unified EIM Database Configuration web page opens. The
following fields are displayed in the configuration area.
following fields are displayed in the configuration area.
Caution
If the database for the Unified EIM/Unified WIM product is not functioning as
designed, the corresponding multichannel reports may display an SQL error
condition. In this case, be sure to verify that the Unified EIM/Unified WIM
database is in service and that the Cisco CRS network connection to the database
is active.
designed, the corresponding multichannel reports may display an SQL error
condition. In this case, be sure to verify that the Unified EIM/Unified WIM
database is in service and that the Cisco CRS network connection to the database
is active.
Step 3
Click Update.
The information is updated in the CRS database using the configuration objects.
Truncating Database Transaction Log Files
The db_cra_log.ldf database transaction log file can become very large. This log
file is stored in the <CRSSQLServerInstallationDirectory>\Data directory (for
example, c:\Program FIles\Microsoft SQL Server\MSSQL$CRSSQL\Data) on
any CRS Server with an Historical Datastore component.
file is stored in the <CRSSQLServerInstallationDirectory>\Data directory (for
example, c:\Program FIles\Microsoft SQL Server\MSSQL$CRSSQL\Data) on
any CRS Server with an Historical Datastore component.
The Cisco CRS runTruncateHistDBLogs command line tool can truncate this
file to a size that you specify. You can run this command from a Microsoft
Windows command window.
file to a size that you specify. You can run this command from a Microsoft
Windows command window.
Field
Description
Host Name
The IP address or host name of the Unified EIM or Unified WIM database
server.
server.
Database Name
The database name of the Unified EIM or Unified WIM server.
Database User
The user name of the Unified EIM or Unified WIM database server.
Database Password
The encrypted form of the Unified EIM or Unified WIM user password.