This procedure describes how to perform a transaction log backup.
Set the Recovery Model setting to either Full or Bulk-logged.
In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.
In the right pane, select one or more databases whose transaction logs you want to back up.
From the drop-down list, select the transaction log option. For more information, see the following table.
To view the progress of the backup, select File > View status.
More Information