question

ro-luko avatar image
0 Votes"
ro-luko asked AnuragSharma-MSFT answered

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

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!

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @ro-luko, 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

118059-image.png

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

118202-image.png

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


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





image.png (15.7 KiB)
image.png (47.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.