SQL Server Transaction Log FILE?

SQL Server Transaction Log


There has always been some debate as to whether or not there are real benefits to be gained from accessing the information in the transaction log. This article will endeavor to answer that question by looking at the following:


What is the SQL Server Transaction Log?
What information is stored in the transaction log?
What can be gained by accessing the information in the transaction log?
How does the transaction log work?
What tools are available for reading the transaction log?
And ultimately, is this something we should be doing at all?