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


SQL Server Transaction Log Tutorial

By:   |   Last Updated: 2014-04-15   |   Comments (2)   |   Related Tips: More > Database Administration

Read the tutorial!

In this tutorial, we値l 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.

Read the tutorial!

Last Updated: 2014-04-15

get scripts

next tip button

About the author
MSSQLTips author Brady Upton Brady Upton is a Database Administrator and SharePoint superstar in Nashville, TN.

View all my tips
Related Resources

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.


Thursday, December 04, 2014 - 5:37:02 PM - Greg Robidoux Back To Top

Hi Shayma,

there is not an easy to print the tutorials right now.  Sorry about that.


Thursday, December 04, 2014 - 5:22:45 PM - Shayma Back To Top

Can we save or print these tutorials? thanks for any advice.

Learn more about SQL Server tools