Progress
Database Administration
Guide and Reference


Duration Of Offline Applications

The type of backup you perform depends on how long you can take the database offline while you back it up. Table 6–5 provides examples.

Table 6–5: Availability and Backup Time 
If the Application Can Be Offline . . .

Then Perform . . .
Never
Online backups with after-image files.1
Eight hours per week
Weekly offline backups with daily online full or incremental backups. For daily backups, use incremental backups to avoid switching tapes during the backup, or to reduce the amount of time spent performing the backup.2
Eight hours per day
Daily offline backups.
  1. After-image files let you switch after-image extents without taking the database offline.
  2. The amount of time you save by performing incremental backups depends on the speed of the backup device.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095