Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Introduction to the SQL Server Transaction Log Tutorial


In this tutorial, we’ll go over some of the tasks you can do to manage the transaction log. The transaction log is very important to SQL Server and there are books alone that discuss how to manage the log so this will be an introduction tutorial to the transaction log.

Some questions that I hope to answer in this tutorial include:

  • What is the transaction log?
  • Why does SQL Server require a transaction log?
  • What is a transaction?
  • What is a nested transaction?
  • How does Mirroring, Replication, and Log Shipping use the transaction log?
  • Why does the transaction log grow?
  • What is a Virtual Log File (VLF)?
  • How to monitor transaction log growth.
  • How to shrink the transaction log.
  • How large should the transaction log be?
  • Do multiple transaction logs help performance?
  • What are the recovery models and how does the log use them?
  • How to recover data using a transaction log backup.

Last Update: 3/25/2014

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools