The Reminders tab - SQL Backup

The Reminders tab displays reminders to set up backup verification for your database backups. You can use SQL Backup to verify your backups by creating a scheduled restore job to regularly restore a database from your backups, and run a database integrity check (DBCC CHECKDB) to confirm the backup can be used.

You can create a reminder to verify your backups when you create a scheduled full backup job using the Schedule Backup Jobs wizard. A reminder is created for each database included in the scheduled backup job. To view details of the backup job schedule, click .

Details of other backup jobs created at the same time, such as scheduled differential or transaction log backup jobs, are also included in the reminder. For example, if you select both Full and Transaction log backups on step 2 of the Schedule Backup Jobs wizard, and then select Create reminder, the details of the transaction log backup schedule will also be listed.

Click Schedule a restore now to launch the Schedule Restore Jobs wizard. The wizard is populated with details from the backup job, including the name of the source database and the location of the backup files. You can include a database integrity check (DBCC CHECKDB) as part of the restore job to verify that the backup can be used.

Note that you do not have to wait for a scheduled backup to be created before creating the scheduled restore job.

When you complete the Schedule Restore Jobs wizard, the reminder is removed from the Reminders tab. If you exit the wizard without creating a scheduled restore job, the reminder remains in the Reminders tab. To remove all or selected reminders from the Reminders tab, use the buttons in the bottom right-hand corner of the tab.