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 ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial