Administrator's Guide

82 Cisco Unified Web and E-Mail Interaction Manager System Administration Guide
Configuring anti-virus protection
Anti-virus protection is necessary, but enabling all files for virus scan may cause performance issues.
 Exclude .mdf, .ldf, .ndf, and .dat files from virus scan.
Routine maintenance tasks
Rebuilding indexes
Rebuilding of indexes enhances database performance.
 Run rebuild index jobs on a weekly basis during off peak hours.
Optimizing database file space
At times, the transaction log may grow considerably, especially if the recovery model of the database is set to
“Full.” Although the active portion of transaction logs is committed after checkpoint or truncated after
transaction log backups, the free space within the transaction log file may not be released to the operating
system. This could lead to disk space crunch.
 Run a space optimization job every day during off peak hours to release the free space within the transaction
logs back to the operating system.
Performing disk defragmentation
 Weekly defragmentation is recommended. Note that it requires downtime.
Creating backup copies
Backups are critical in case of hardware failure. The following backup policy ensures that you won’t lose more
than one hour of data. SQL supports full recovery model and hence this policy is strongly recommended. When
torn_page_detection on
compatibility level 80 for 2000
database auto grow on
transaction log auto grow on