Online Documentation for SQL Administrator for SQL Server

Specifying transaction log backup options


Use this step to set parameters for transaction log backup. This step appears only if the !RadioButton Transaction log option was selected on the second step.

 

Backup Database Wizard - Specifying  transaction backup options

 

 

!RadioButton Truncate inactive log items

The log is truncated after all the records within one or more virtual log files become inactive.

 

!RadioButton Don't truncate transaction log

This option specifies that the log is not truncated and causes the Database Engine to attempt the backup regardless of the state of the database.

Note: A backup taken with this option might have incomplete metadata.

 

!RadioButton Back up the tail of the log and leave the database in the restoring state

This option creates a tail-log backup, which backs up logs that have not yet been backed up (the active log), typically, in preparation for restoring a database. The database will be unavailable to users until it is completely restored.

 

!RadioButton Back up the tail of the log and leave the database in a read-only and standby state

Use this option to back up the tail of the log and leave the database in a read-only and standby state. The standby clause writes standby data (performing rollback, but with the option of further restores).

Provide Standby file name in the corresponding field. The standby file becomes part of the database. It holds the rolled back changes, which must be reversed if RESTORE LOG operations are to be subsequently applied.