Episode 163 - When and Why to HADR

Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them.

Relevant links for further reading:

• AlwaysOn Basic Availability Groups / Database Mirroring
• AlwaysOn "Enterprize" Availability Groups
• Failover Cluster Instance
• Log Shipping
• Transactional Replication