thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Active Geo-Replication

An Azure SQL Database feature that maintains up to four readable secondary databases in the same or other regions using asynchronous replication.

Definition

Geo-replication provides disaster recovery and read scale-out per database. Failover is manually initiated and requires the application to change its connection string. It is not supported for Azure SQL Managed Instance, which uses failover groups instead.

Exam tip

Geo-replication is per database with manual failover; failover groups add group failover and stable endpoints.

Related terms