Using Azure SQL fail-over-group and geo-replication feature together

Question

I am doing a proof-of-concept with Azure SQL with below configuration, let me know if using both fail-over-group and geo-replication together has any potential downsides?

I have SQL Server A,B,C,D in different regions.

A and B are part of same fail-over-group.

A also geo replicates to DB in Servers C and D.

When I failover from SQL server A to B, I also see that C and D now recognizes B as the new primary which is the behavior that I am looking for. But I couldn't find any documentation to support this. Would nice to get confirmation on this behavior.

• Thanks!

Answer 1

Hi @Rohan Lukose , welcome to Microsoft Q&A forum.

You are right in mentioning that if failover is initiated from Server A to Server B, geo-replicated replicas will also have their primary changed to Server B. You can read the same in the below article:

Creating and using active geo-replication - Azure SQL Database

Also while doing the manual failover also, we get the same message as shown in below screenshot:

Please let me know if this helps or else we can discuss further.

----------

If answer helps, you can mark it 'Accept Answer'