High Availability - Disaster Recovery 101

Explore the fundamentals of High Availability and Disaster Recovery for SQL Server 2019 in this comprehensive 55-minute conference talk from PASS Data Community Summit. Learn how to design an infrastructure that meets specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels by comparing various HA/DR technologies. Discover how to combine these technologies to build robust solutions that align with your organization's HA/DR goals. Gain insights into crucial aspects such as technology choices, licensing considerations, and the development of effective policies and procedures. Delve into topics including planned and unplanned downtime, Availability Groups, backup and restore methods, scaling strategies, component redundancy, failover duration, storage options, Windows failover clustering, and various replication techniques. Equip yourself with the knowledge to create a solid disaster recovery strategy and implement the right policies to ensure your chosen technologies work effectively in your specific environment.