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.
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.