Jump to ratings and reviews
Rate this book

SQL Server Transaction Log Management

Rate this 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.

232 pages, Paperback

First published December 21, 2012

1 person is currently reading
15 people want to read

About the author

Tony Davis

27 books1 follower

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
3 (37%)
4 stars
4 (50%)
3 stars
1 (12%)
2 stars
0 (0%)
1 star
0 (0%)
Displaying 1 - 4 of 4 reviews
Profile Image for Vera VB.
1,503 reviews6 followers
June 27, 2013
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.
The book contains a lot of links to other free books and articles.

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

Profile Image for John Deardurff.
310 reviews5 followers
September 27, 2020
Another book I originally read about 5 years ago, but am revisiting. This is actually one of the free ebooks you can get from Redgate Software. I think I picked this copy up at the Redgate booth at TechEd Houston back in 2014. Let's just say that 208 pages about SQL Server Transaction Logs are just about as in-depth as you are going to get on the subject. Easy to read and follow. I especially large the larger font for these older eyes. My favorite part is Chapter 2 discussing Virtual Log Files which has always just escaped my understanding. But in this book, the examples and explanations were the best I have seen and allowed me to finally get the concept. Thank you, Tony, Gail, and Kalen.
Profile Image for Mark Polino.
Author 42 books9 followers
December 11, 2014
SQL Server Transaction Log has more information about the SQL Transaction log than I ever wanted to know. It's a fabulous reference. Well done.
Displaying 1 - 4 of 4 reviews

Can't find what you're looking for?

Get help and learn more about the design.