Specify the Database Backup Plan

Use the Specify the Database Backup Plan screen to view or specify the following options.

Options

Back up the database as part of the maintenance plan

Cause the entire database to be backed up as part of the maintenance tasks. Backing up the database is important in case of system or hardware failure (or user errors) that cause the database to be damaged in some way, thus requiring a backed-up copy to be restored.

Verify the integrity of the backup on completion of the backup

Check that the backup set is complete and all volumes are accessible by executing the RESTORE VERIFYONLY Transact-SQL statement.

Tape

Back up the database to the specified tape device. Only tape devices attached to the computer containing the database are available.

Disk

Back up the database to disk. For more information about how to specify the location of the database backup, see Specify Backup Disk Directory.

Schedule

Set the frequency that the database backup tasks (scheduled using SQL Server Agent) are executed. The default is every Sunday at 2:00 AM.

Change

Change the default schedule.