How to: Create a Transaction Log Backup (Transact-SQL)

This topic explains how to create a transaction log backup using a BACKUP LOG statement. ... Execute the BACKUP LOG statement to back up the transaction log, specifying the following: The name of the database to which the transaction log that you want to

technet.microsoft.com