Active geo-replication
Active geo-replication is one of the most important business continuity methodologies.
When using active geo-replication, you can configure up to four secondary databases within the same region or in different regions with reading access. This will help to reduce latency for users or applications that need to query the database from a different region.
If a catastrophic disaster occurs, you can failover to the other region using a failover group.
Failover groups are mainly designed to manage every aspect of geo-replication automatically, such as connectivity, relationships, and failover. Considering that it is enabled across Azure SQL Database Basic and Standard service tiers.
Implementing active geo-replication
To get active geo-replication implemented, follow these steps:
- Navigate to the desired database on the Azure portal and click on
Geo-Replication
underSETTINGS
, as shown in the following screenshot:

Figure 5.16: Active geo-replication
- Click on the region you want...