Avaya Compact Contact Center V5, Руководство системного администратора

Страница: 63 / 67

System Administrator
System Administrator Page 63
Compact Contact Center V5 40DHB0002USDU Issue 2b (1st February 2005)
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.
• Note
If the program 'Database Server Supervisor' has been installed, you are able to use the tools
provided within it to create and schedule backups.
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.
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 you need to restore the database from a backup created above, please contact your field engineer for
help.
Tape Backup
This task is disabled by default and cannot be used when only the MSDE database is installed.