Click here to monitor SSC
  • Av rating:
  • Total votes: 22
  • Total comments: 5

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

10 June 2013

Free eBook download (PDF): From Red Gate
Kindle edition: Kindle US | Kindle UK
Buy the printed book: |

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

In this book, we strive to offer just the right level of detail so that every DBA can perform all of the most important aspects of transaction log management. We cover:

  • The critical role of the SQL Server transaction log and write ahead logging
  • How to perform transaction log backup and restore in FULL and BULK_LOGGED recovery models
  • Managing log growth, and dealing correctly with an overgrown or full log
  • Optimizing log throughput and availability, and how to avoid log fragmentation

In short, our book will show you how to control your transaction log, so that it doesn't control you.

Tony Davis and Gail Shaw

Author profile:

Tony Davis is an Editor with Red Gate Software, based in Cambridge (UK), specializing in databases, and especially SQL Server. He edits articles and writes editorials for both the and websites and newsletters, with a combined audience of over 1.5 million subscribers. You can sample his short-form written wisdom at either his blog, or his author page.

Gail Shaw is a senior consultant with Xpertease and is based in Johannesburg, South Africa. She specializes in database performance tuning and database recovery, with a particular focus on topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail is a Microsoft Certified Master for SQL Server 2008 and a SQL Server MVP. She is a frequent poster on the SQL Server Central forum, writes articles for both and and blogs on all things relating to database performance on her SQL in The Wild blog. She has spoken at TechEd Africa, the 24 Hours of PASS web event and, on multiple occasions, at the PASS Community summit.

Search for other articles by Tony Davis and Gail Shaw

Rate this article:   Avg rating: from a total of 22 votes.





Must read
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.

Subject: When is this book expected?
Posted by: roac (view profile)
Posted on: Tuesday, February 12, 2013 at 5:07 AM
Message: The status of this book has been "Coming Soon" for nearly four months now, when can we expect it? I would not call four months soon.

Subject: I got it!
Posted by: ram140281 (view profile)
Posted on: Tuesday, May 21, 2013 at 7:33 AM
Message: I ordered this book from and I got it in India within 15-21 days.

Subject: awesome book
Posted by: ram140281 (view profile)
Posted on: Friday, May 24, 2013 at 12:36 AM
Message: It is the book focused on T. Log and T.Log Backup/Restore.

Subject: Evey DBA should read this
Posted by: blackalex (view profile)
Posted on: Thursday, June 27, 2013 at 3:54 AM
Message: I read this book front to back and it's really good. Every DBA-in-spe or oldtimer should read this because it clarifies a lot of mysteries about the log file. It gives specific answers and nice examples to proof its point. There is a lot of BS to read in forums about the transaction log file, about what to do and not to do with it. Read this book and you will know what to do.

Big congratulations for the authors and thank you for making it available for free.

Kind Regards,
Vera Van Boxel - DBA at the Institute of Tropical Medicine Antwerp

Subject: Excellent Book on Tran. Log and Database Backup & Recovery
Posted by: ram140281 (view profile)
Posted on: Friday, October 25, 2013 at 9:28 AM
Message: I like to say three words for this book - Excellent! Excellent! Excellent!

Big congratulations to author Gail Shaw & technical reviewer Kalen Delaney


Recommended site is a user-driven wiki which provides .NET developers with native method signatures, so they don't have to spend time writing them from scratch.

Check out!

Top Rated

SQL Server Source Control Basics
 For efficient team-based database development, and reliable and repeatable database deployments, source... Read more...

Tribal SQL
 Tribal SQL, is a reflection of how a DBA's core and long-standing responsibilities sit alongside new... Read more...

Book Review: Optimizing And Troubleshooting Hyper V Networking 2013
 If you want to learn how to optimize and troubleshoot Hyper-V, then this book, written by Microsoft... Read more...

Don't Just Roll the Dice - eBook Download
 Neil Davidson has created a short handbook with the theory, practical advice and case studies, to... Read more...

Captain Biplane: Interplanetary Airman
 Simple-Talk caters for the lighter side with its publication of 'Captain Biplane: Interplanetary... Read more...

Most Viewed

Troubleshooting SQL Server: A Guide for the Accidental DBA
 Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide... Read more...

Exchange 2010 - A Practical Approach
 Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use... Read more...

Brad's Sure Guide to SQL Server Maintenance Plans
 Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to... Read more...

SQL Server Hardware
 SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent... Read more...

Inside the SQL Server Query Optimizer
 This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the... Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.