16 October 2012

  • 24

  • 29,759 views

  • 0

16 October 2012

29,759 views
24 0

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.

Redgate SQL Monitor

SQL Monitor helps you manage your entire SQL Server estate from a single pane of glass. Proactively mitigate potential risks with instant problem diagnosis and customizable alerting – wherever your databases are hosted. No downtime, customer complaints, or wake-up calls at 3am.

Find out more

  • 24

  • 29,759 views

Rate this article

Click to rate this post!
[Total: 4 Average: 1.8]

Tony Davis

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.

Follow Tony Davis via

View all articles by Tony Davis

Load comments

Related articles

 28 February 2022
28 February 2022

Azure: Small Changes that Matter

0
2
I believe I’m not alone on this feeling: It seems like every time we use the Azure Portal some new feature appear. The features reproduce themselves faster than rabbits. Did you had this feeling before? Share your thoughts in the comments. This week, working with Azure, I found some new small features around and decided … Read more
0
2
26 March 2012
26 March 2012

SQL Backup and Restore

0
39
A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.… Read more
0
39

Tags

, , , , , , , ,