16 October 2012

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When things go wrong, a DBA's reputation depends on an 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.
This book shows you how to control your transaction log, so that it doesn't control you.

1577-SQL-Server-transaction-logs_x200_gr

Free eBook download (PDF): From Red Gate
Kindle edition: Kindle US | Kindle UK
Buy the printed book: Amazon.com | Amazon.co.uk

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.

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

This post has been viewed 19186 times – thanks for reading.

Tags: , , , , , , , ,

  • Rate
    [Total: 21    Average: 4.5/5]
  • Share

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 Simple-talk.com and SQLServerCentral.com websites and newsletters, with a combined audience of over 1.5 million subscribers. You can sample his short-form writing at either his Simple-Talk.com blog or his SQLServerCentral.com author page.

As the editor behind most of the SQL Server books published by Red Gate, he spends much of his time helping others express what they know about SQL Server. He is also the lead author of the book, SQL Server Transaction Log Management.

In his spare time, he enjoys running, football, contemporary fiction and real ale.

View all articles by Tony Davis

  • roac

    When is this book expected?
    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.

  • ram140281

    I got it!
    I ordered this book from uread.com and I got it in India within 15-21 days.

  • ram140281

    awesome book
    It is the book focused on T. Log and T.Log Backup/Restore.

  • blackalex

    Evey DBA should read this
    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

  • ram140281

    Excellent Book on Tran. Log and Database Backup & Recovery
    I like to say three words for this book – Excellent! Excellent! Excellent!

    Big congratulations to author Gail Shaw & technical reviewer Kalen Delaney