To implement a backup and recovery plan

1. Create and verify your backup and recovery commands, including commands for database validation. See Validating backups.

2. Measure the time it takes to execute backup and recovery commands.

3. Document the backup commands and create written procedures outlining where your backups are kept. The procedures should identify any naming conventions that are used, and the type of backups that are performed.

4. Set up your backup procedures on the production server.

5. Monitor backup procedures to avoid unexpected errors. Make sure any changes in the process are reflected in your documentation.

See also

• Full backups
• Incremental backups
• Understanding backups
• Backing up databases involved in synchronization and replication
• Backup and recovery restrictions
• Types of backup
• Choosing a backup format