Specify Transaction Log Backup Disk Directory

Database Maintenance Plan

Database Maintenance Plan Wizard Help

Specify Transaction Log Backup Disk Directory

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


Use the default backup directory

Back up the transaction log to the default backup disk directory located on the computer that contains this transaction log. This is the \MSSQL\BACKUP directory for default instances of Microsoft® SQL Server™ 2000, and the \MSSQL$instancename\BACKUP directory for named instances of SQL Server 2000.

Use this directory

Back up the SQL Server transaction log to the specified disk directory that is located on the computer containing this transaction log. Click the browse (...) button to change the default disk directory used to back up the transaction log. Only drives on the computer containing the specified SQL Server transaction log can be selected.

Create a subdirectory for each database

Create a subdirectory under the specified disk directory for the transaction log backup for each database that is being backed up as part of the maintenance plan.

Remove files older than

Delete automatically any transaction log backups older than the specified period. A history of transaction log backups should be maintained in the event that the database needs to be restored to a specific point in time. Retain as many backups as disk space allows and as far in the past as necessary.

Backup file extension

Define the file extension for each file containing a transaction log backup. The default file extension is .trn.

Note  Disk backup file names are generated automatically (for example, pubs_tlog_199803120203.bak where 199803120203 is the timestamp).