Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Specify Transaction Log Backup Plan

SQL Server 2000

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.

© 2015 Microsoft