Chapter 8

High Availability and Disaster Recovery

Learning Objectives

By the end of this lesson, you will be able to do the following:

  • Describe built-in high-availability features in SQL Database
  • Implement standard and active geo-recovery for Disaster Recovery (DR) solutions
  • Implement standard and active geo-replication
  • Implement the Accelerated Database Recovery feature

This lesson will teach you about the built-in high availability in Azure SQL Database. It'll also teach you how to implement a DR solution using standard and active geo-replication.

High Availability

High availability refers to providing business continuity when the physical server hosting Azure SQL Database fails.

As discussed in Lesson 1, Microsoft Azure SQL Database ...

Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.