Filter
Top Products
Administering the Database Overview
Compact Contact Center Installation & Maintenance
40DHB0002USBG Issue 1 (11/14/2001) Administering the Database
•
Page 28
Administering the Database
Overview
If you have installed the MSDE database, four scheduled tasks are installed
automatically. The parameters cannot be configured, listed below is a
description of each scheduled task's function. If you have purchased and
installed Microsoft SQL 2000 you can use the tools provided to create and
schedule backups etc.
Disk Backup
This task is enabled by default and scheduled to run once a week on a
Sunday at 2 am. It backs up the SDXArchiver database to the default
backup directory, which is d:\microsoft sql\server\mssql\backup. At the
same time any backup that is more than 4 weeks old is deleted.
Tape Backup
This task is disabled by default and cannot be used when only the MSDE
database is installed.
Integrity Check
This task is enabled by default and is scheduled to run once a week on a
Sunday at 1 am. It checks for any problems/corruption in the SDXArchiver
database and automatically fixes any minor faults that are found without
affecting any data.
Optimizations
This task is enabled by default and is scheduled to run once a week on a
Sunday at 1 am. For each table in SDXArchiver, a 10% sample of the data
is taken and used to update the statistics used by the query optimize (an
engine used to analyze queries and determine the quickest way to return
the data being queried for).
Restore
If needed to restore from a backup created above, please contact your field
engineer for help.