The Cisco Customer Response Application (CRA) database log files, the tempdb database or the tempdb log files have become large.
To resolve this issue, choose from one of these actions:
To manually shrink a Cisco CRA database log file, open a command window on the Cisco CRA server and issue these commands:
osql -Usa -Ppassword -ddb_cra, where password is the password for the SA log in to the Cisco CRA database
USE database_name, where database_name is db_cra or db_cra_ccdr, depending on the Cisco CRA database that you want to shrink
DBCC SHRINKFILE (database_name_log.mdf), where database_name is db_cra or db_cra_ccdr, depending on the Cisco CRA database that you want to shrink
Alternatively, you can shrink the log files by running the batch file runTruncateHistDBLogs.bat, installed under the wfavvid directory. Depending on the arguments, it shrinks the log files of db_cra, db_cra_ccdr or tempdb.
These are some examples:
Truncate the log files for both db_cra and db_cra_ccdr to 10 MB: