Scheduling Routine Backups

Make a full backup of each database just after you create it, to provide a base point, and perform full and incremental backups on a fixed schedule thereafter. It is especially important to back up your database after any large number of changes.

Your backup plan depends on:

The load on your system
The size of your database
The number of changes made to the data
The relative importance of faster backups and faster recovery

Determining the Type of Backup
When you decide whether to do a full, incremental, or incremental_since_full backup, you need to balance the time it takes to create the backup with the time it would take to restore.

Parent topic: Determining Your Data Backup and Recovery Strategy