Cisco Cisco Unified Customer Voice Portal 11.0(1)

Database Sizing Issues

See the discussion in 

. Also see the Planning Guide for Cisco Unified

Customer Voice Portal and the Cisco Unified Customer Voice Portal (CVP) Release 7.x Solution
Reference Network Design (SRND) document.

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 Guide for Cisco Unified Customer Voice Portal Release 7.0(1)