SQL Server Transaction Log Tutorial


By:   |   Updated: 2014-04-15   |   Comments (2)   |   Related: 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 does BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN mean?
  • 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.

-Greg


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

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



download

























get free sql tips

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