How to create a transaction log backup (Transact-SQL)

To create a transaction log backup


Important The transaction log should not be backed up:


  1. Execute the BACKUP LOG statement to back up the transaction log, specifying:
  2. Optionally, specify:

Important Use extreme caution when using the FORMAT or INIT clauses of the BACKUP statement as this will destroy any backups previously stored on the backup media.


Examples

This example creates a transaction log backup for the MyNwind database to the previously created named backup device MyNwind_log1.

BACKUP LOG MyNwind

    TO MyNwind_log1

GO

  

See Also
BACKUP Creating and Applying Transaction Log Backups
Restoring a Database to a Prior State Using Differential Database Backups with Transaction Log Backups
Creating File or Filegroup Backups  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.