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. Read more