Specify Transaction Log Backup Plan
Use the Specify Transaction Log Backup Plan screen to view or specify the following 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.
Back up the database to the specified tape device. Only tape devices attached to the computer containing the database are available.
Back up the database to disk. For more information about how to specify the location of the database backup, see Specify Backup Disk Directory.
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.