High Availability - Disaster Recovery 101 - Data Architecture

Explore the fundamentals of High Availability and Disaster Recovery for SQL Server 2017 in this comprehensive 49-minute conference talk by Glenn Berry at PASS Data Community Summit. Learn how to design an infrastructure that meets specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels. Discover various HA/DR technologies available in SQL Server 2017, including backup and restore methods, Windows Failover Clustering, Intel Optane DC Storage, database mirroring, peer-to-peer replication, and log shipping. Compare these technologies and understand how to combine them effectively to build robust solutions. Gain insights into technology choices, licensing considerations, and the importance of implementing appropriate policies and procedures. Delve into the causes of downtime, data loss, and reasons for planned downtime. Examine high availability features across different SQL Server editions and address crucial disaster recovery planning considerations, including people issues. Equip yourself with the knowledge to develop comprehensive HA/DR strategies tailored to your organization's needs.

Intro
Definition of High Availability
What is the "Something"?
Causes of Downtime and Data Loss
Reasons for Planned Downtime
Planning a High Availability Strategy
SQL Server 2017 HA-Related Technologies
Backup and Restore Methods
Windows Failover Clustering
Intel Optane DC Storage
Database Mirroring
Improvements in SQL Server 2017
Peer-to-Peer Replication
Log Shipping
High Availability Features by Edition
More DR Planning Considerations
DR Planning: People Issues
Summary