Avaya 38HBK00001SCM manual Creating Database Backup, Database - Complete

Administering Database Creating Database Backup

Creating Database Backup

When creating a database backup, the backup operation copies only the data in the database to the backup file; it does not copy out unused space in the database. Because the database backup contains only the actual data in the database, not any empty space, the database backup is likely to be smaller than the database itself.

If you are producing database backups only, the backup interval should be long enough to keep the backup overhead from affecting production work, yet short enough to prevent the loss of significant amounts of data. Databases that do not contain critical data and have few modifications can be backed up on a weekly or biweekly basis. Data that is more critical or more volatile may need to be backed up daily, or even more frequently. Some databases that are usually read-only may need to be backed up only after a periodic refresh with new data.

Note

If any files are added or removed from a database, a database backup should be created immediately.

Database - Complete

During the installation of the Report Manager, Backup administration is configured and the SDXArchiver database is automatically backed-up in the D:\MSSQL7 drive. To change the location of the backup destination to the Tape Drive, perform the following procedure.

Note

Ensure the Tape drive is already installed to be able to change the destination of the database backup drive.

1.From the Windows NT Taskbar, click the Start button, point to Programs and Microsoft SQL Server 7.0 and then select Enterprise Manager, the following screen appears:

INDeX Contact Centre Modules	Page 79
Installation & Maintenance	38HBK00001SCM - Issue 11 (05/01)