Cisco Cisco Unified Customer Voice Portal 10.5(1)

Database Backup and Recovery

Issues to keep in mind are:

• Managing your backup strategy

• Turning off Reporting Server when doing database recovery

These are discussed in 

Database Retention Settings

Ensure that the database is sized conservatively so that it never needs to emergency purge.

Purge and Backup Database Maintenance Tasks

The database backup and purge maintenance tasks are created as Windows Scheduled Tasks,
and can be viewed in the Scheduled Tasks window (Start > Programs > Accessories > System
Tools

 > Scheduled Tasks). These jobs log in as SYSTEM.

If the CVPDBNightlyPurge and CVPDBMidDayPurge tasks do not run, then the database will
not be purged and will eventually become full, resulting in data loss.

If the CVPDBBackup task does not run the database will not be backed up.

Periodically, you should check the Scheduled Tasks to ensure the Last Run Time was as expected
and there are no status messages.

Allow Only Reporting Users when Querying the Database

In the interests of security, allow only reporting users to generate reports.

Reporting Isolation Level

Reporting clients should never run with an isolation level of repeatable read as this could hold
locks and prevent updates to the data.

Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(2)