Disaster Recovery

Disaster recovery refers to having business continuity in case of a natural disaster or hacking that terminates an entire Azure region.

There are two ways to implement disaster recovery: Standard Geo-replication and Active Geo-replication.

Standard Geo-Replication

Standard Geo-replication asynchronously replicates committed transactions from an online primary to an offline secondary in a predefined Azure region:

Standard Geo-Replication

Figure 8.4: Standard Geo-Replication

In standard geo-replication:

  • Only one secondary is allowed in a DR paired region. Each region has a DR pair that can only host the secondary database. The list of DR paired regions is here: ...

Get Professional Azure SQL Database Administration 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.