Simple Talk is now part of the Redgate Community hub - find out why

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.

How you log in to Simple Talk has changed

We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue

Simple Talk now uses Redgate ID

If you already have a Redgate ID (RGID), sign in using your existing RGID credentials. If not, you can create one on the next screen.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue