Microsoft® SQL Server 2012 Unleashed

Creating Transaction Log Backups with T-SQL

When you back up a transaction log by using T-SQL, you use the BACKUP LOG command, which includes all the previously listed options except the DIFFERENTIAL option. (Differential backups do not apply to transaction logs.) Several additional options are available for transaction log backups. The following abbreviated syntax for the BACKUP LOG command shows the options used exclusively for backing up transaction logs:

Click here to view code image

BACKUP LOG { database_name | @database_name_var }TO < backup_device > [ ,...n ][ [ MIRROR TO < backup_device > [ ,...n ] ] [ ...next-mirror] ][ WITH......     [ [ , ] NO_TRUNCATE ]     [ [ , ] { NORECOVERY | STANDBY = undo_file_name } ]

The options specific to ...