Filter
Top Products
Administering Database Creating Database Backup
INDeX Contact Centre Modules Page 79
Installation & Maintenance 38HBK00001SCM - Issue 11 (05/01)
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: