question

DavidC-7877 avatar image
0 Votes"
DavidC-7877 asked Cathyji-msft commented

AlwaysOn failover to DR node

Hi. I have a typical 3-node cluster with 2 x HA nodes in primary data center with synchronous commit, and 1 x DR node in remote data center with asynchronous commit and manual failover. I'm referring to what is the prod cluster. I would like to simulate a DR scenario where the primary data center is unavailable. Can I change the availability mode of the secondary replica on the remote node from asynch to synch with manual failover, do a failover from the primary data center to remote data center, then fail back again to the former primary node? Thanks.

sql-server-general
· 1
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.

Hi @DavidC-7877,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @DavidC-7877,

From your description, did your configuration as belowscreenshot? If I misunderstood, please let me know.

94649-screenshot-2021-05-07-141438.jpg

Can I change the availability mode of the secondary replica on the remote node from asynch to synch with manual failover, do a failover from the primary data center to remote data center, then fail back again to the former primary node?

Yes, you can do that. If you want AG auto failover when the primary down, suggest you change it to synch with auto failover.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.




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.