Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Regular backups and tested recovery commands are part of a comprehensive backup and recovery plan. See Designing a backup and recovery plan.
Create and verify your backup and recovery commands.
Measure the time it takes to execute backup and recovery commands.
Document the backup commands and create written procedures outlining where your backups are kept and identify any naming convention used, as well as the kind of backups performed.
Set up your backup procedures on the production server.
Monitor backup procedures to avoid unexpected errors. Make sure any changes in the process are reflected in your documentation.