SQL Server Transaction Log Management

SQL Server Transaction Log Management

This book offers just the right level of detail so that every DBA can perform all of the most important aspects of transaction log management.

Publication date: 01 Oct 2012

ISBN-10: n/a

ISBN-13: 9781906434946

Paperback: 209 pages

Views: 1,424

Type: Book

Publisher: Simple Talk Publishing

License: n/a

Post time: 25 Apr 2017 07:30:00

SQL Server Transaction Log Management

SQL Server Transaction Log Management This book offers just the right level of detail so that every DBA can perform all of the most important aspects of transaction log management.
Tag(s): Relational Database
Publication date: 01 Oct 2012
ISBN-10: n/a
ISBN-13: 9781906434946
Paperback: 209 pages
Views: 1,424
Document Type: Book
Publisher: Simple Talk Publishing
License: n/a
Post time: 25 Apr 2017 07:30:00
From the Book Description:
Davis and Shaw wrote: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.

More Resources:




About The Author(s)


Tony Davis is an Editor with Redgate 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 written wisdom at either his Simple-Talk.com blog, or his SQLServerCentral.com author page.

Tony Davis

Tony Davis is an Editor with Redgate 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 written wisdom at either his Simple-Talk.com blog, or his SQLServerCentral.com 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 SQLServerCentral.com and Simple-Talk.com and blogs on all things relating to database performance on her SQL in The Wild blog.

Gail Shaw

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 SQLServerCentral.com and Simple-Talk.com and blogs on all things relating to database performance on her SQL in The Wild blog.


Book Categories
Sponsors
Icons8, a free icon pack