Specify Transaction Log Backup Plan

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

Options

Backup the transaction log as part of the maintenance plan

Cause the transaction log to be backed up as part of the maintenance plan. Backing up the transaction log is necessary in order to recover the database to the point of failure.

Verify the integrity of the backup when complete

Check that the backup 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 transaction log backup tasks (scheduled using SQL Server Agent) are executed. The default is every Monday through Friday at 12:00 midnight.