Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Backup Strategies : Creating a backup schedule : Time
When creating a backup schedule, consider both the time required to perform backups and the time required to recover a database from the backups:
*Performing daily full backups of your system might require too much time. If you make few updates to the database each day, a daily full backup might be unnecessary. Thus, you might want to perform daily incremental backups and a weekly full backup. If you have after-imaging enabled, remember to back up the after-image files for both incremental and full backups.
*If you perform full backups less than once a week, you must maintain multiple incremental backups, which makes recovery more complicated and prone to operator error. Restoring a backup becomes a multi-step process of first restoring the last full backup, then restoring the subsequent incremental backups.
*If you enable after-imaging, you can perform daily backups of the after-image file instead of performing incremental backups. However, recovering from the AI file backups requires restoring the AI files then rolling forward through multiple after-image files. This is more time intensive than restoring a full backup with PROREST. Because backing up AI files backs up whole transactions instead of just the blocks that have changed since the most recent backup, restoring a database from incremental backups is quicker than restoring AI files and rolling forward the AI files.