Restore Under Pressure · Kai London
SQL Server Disaster Recovery Validation: Test Availability Groups, Restore Chains and Recovery Objectives
Your recovery objectives are written down. Has anyone tested them end to end?
Many SQL Server estates record recovery objectives that no one has ever tested end to end. This independent practitioner reference helps database administrators and recovery owners test availability groups, restore chains and recovery objectives, and keep evidence that the results are real.
Part I is the practitioner guide, covering recovery objectives, editions and options, backup chains, restore testing, availability groups and failover clustering. Part II is the field toolkit: a reference recovery lab, failure-injection drills for high availability, a PowerShell validation module for continuous checks, extended case studies, and annotated registers, matrices, policies and runbooks. Part III is reference and practice, with template libraries, two scenario workbooks of practical and advanced exercises, a tabletop pack, a framework mapping and a glossary. Part IV is an evidence casebook of worked cases, and Appendix A provides checklists.
Specific topics include restore testing of full, differential and log backup chains, availability group failover and replication behaviour, quorum and witness handling in failover clustering, log shipping, cloud disaster recovery, and the dependencies around the database such as logins, jobs and linked services. A recovery proof chapter and a worked case show how to document outcomes.
It is written for database administrators, infrastructure and resilience managers, auditors, and consultants responsible for SQL Server recovery.
Every chapter is built for working professionals: a real headline, a dramatised boardroom scene, decision tables, worked examples with expected results, the evidence to keep, a checklist, the board question and a self-test. The book closes with a capstone assessment, consolidated checklists, model answers, a standards crosswalk, a certification domain map for CISSP, CISM, CRISC and CISA, and a full index.
Professor Kai London