Book Review – SQL Server Transaction Log Management
SQL Server Transaction Log Management is divided into 9 chapters. Chapter 1 examines how SQL Server make use of the trasaction log, writing ahead logging, transactional consistency, controlling the size of the log including an outline of transaction log backup and restore.
Chapter 2 covers virtual log files, log truncation and space reuse. While Chapter 3 provides a detailed coverage of importance of backups, database recivery models and log backup logistics, Chapter 4 examines SIMPLE recovery model along with its pros and cons.
Chapter 5 covers the basics of log backup and the steps required to perform restore and recovery. Chapter 6 examines the advantages of minimal logging, BULK_LOGGED recovery in addition to the implications of minimally logged operations. The author also provides guidelines for best practices for the usage of BULK_LOGGED.
Chapter 7 delves deep into diagnosing a runway transaction log, handling a transaction log full error including guidelines for proper log management.
Chapter 8 examines the physical architecture of log file and usage of a dedicated drive for the log file, RAID 10 for log drives. It also covers log fragmentation and a checklist which you can refer to when things doesn’t work as expected.
The last chapter provides a comprehensive coverage of various monitoring tools such as Windows Perfmon, ReadGate SQL Monitor in addition to usage of T-SQL, SSIS and PowerShell.
SQL Server Transaction Log Management by Tony Davis and Gail Shaw is an excellent material for SQL Server geeks.