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.

Introduction
Who am I
Agenda
What does HA mean
Plan Downtime
Unplanned Downtime
Availability Groups
Allowable Downtime
HA Technologies
Backup Restore Methods
Backup Tuning Options
Secondary Restore Server
Scaling up vs scaling out
Component redundancy
Failover duration
Hardware store choices
Storage choices
RAID
Windows failover clustering
Intel Optane storage
Availability Group
Mirroring
Database Mirroring
Transactional Replication
SQL Server Replication
PeertoPeer Replication
Log Shipping
Log Shipping Example
Database Snapshots
Feature Differences
Disaster Recovery Strategy
Recap
References
Questions