SQL Server Transaction Log Management

Download SQL Server Transaction Log Management, by Tony Davis and Gail Shaw, for free in pdf format from Red Gate Software.

Book Description

It covers performing transaction log backup and restore, monitoring and managing log growth, including quick diagnosis of the causes of rapid growth, and optimizing log architecture to maximize log throughput and availability.

Table of Contents

• Meet the Transaction Log
• Some, But Not Too Much, Log Internals
• Transaction Logs, Backup and Recovery
• Managing the Log in SIMPLE Recovery Model
• Managing the Log in FULL Recovery Model
• Managing the Log in BULK_LOGGED Recovery Model
• Dealing with Excessive Log Growth
• Optimizing Log Throughput
• Monitoring the Transaction Log

Book Download / View Details