Disaster Recovery Strategies for SQL Server

Explore disaster recovery strategies for SQL Server in this 47-minute conference talk by Microsoft Data Platform MVP Andrew Pruski. Learn critical aspects of managing SQL Server, including planning for worst-case scenarios, available technologies, and implementing recovery strategies during crises. Discover the differences between high availability and disaster recovery, understand recovery objectives, and delve into various techniques such as backup and restore, mirroring, and availability groups. Gain insights on monitoring, alerting, enacting disaster recovery plans, and conducting tests. Explore additional implementations and experiments to enhance your SQL Server disaster recovery knowledge.

Introduction
About me
Agenda
Hope is not a strategy
Top 3 DBA tasks
High availability vs Disaster Recovery
Recovery Objectives
Backup and Restore
Mirroring
Availability Groups
Distributed AGS
Monitoring Alerting
Enact Dr
Dr Testing
Other implementations
Experiments