Moving AlwaysOn Replica DR node to new Data Center

Question

Moving AlwaysOn Replica DR node to new Data Center

kmounkhaty

Old Hand

Points: 363
More actions
February 16, 2016 at 12:39 pm

#308468

Hi Forums,
Our current AlwaysOn design is two nodes in primary DC and one replica in DR DC. We want to move the DR node to new data center and we also need to rename, re-IP.
What is the correct approach for this migration?
Really appreciated if anyone could provide just high level direction.
Regards

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234064 More actions · Answer 1

kmounkhaty (2/16/2016)
Hi Forums,
Our current AlwaysOn design is two nodes in primary DC and one replica in DR DC. We want to move the DR node to new data center and we also need to rename, re-IP.
What is the correct approach for this migration?
Really appreciated if anyone could provide just high level direction.
Regards

Your best option would be to remove the secondary database from the availability group, then remove the replica from the availability group.

Once the server has been re positioned and configured, introduce the replica back into the group and setup the secondary database

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

kmounkhaty Old Hand Points: 363 More actions · Answer 2

Thanks very much for the response and that's pretty much I had in mind. After removing databases from AG and removing Replica and databases will be in restoring state mode. Once adding the replica back and restore both differential/log backups to catch up from primary and adding databases back to AG.

Thanks again.

Tom OShea SSC-Addicted Points: 460 More actions · Answer 3

To avoid risk of data loss due to primary dc failure you should add a new node in and get that up and running as a secondary in the AG. Then decom the old node. Depends on your risk appetite during the move. You will also have to add new ip to cluster and AGL if new dc is on a different subnet.

kmounkhaty Old Hand Points: 363 More actions · Answer 4

We do have another 2nd replica on primary DC with sync setup. Once SQL AlwaysOn part is done then Windows guy will remove it from cluster, rename the host and re-IP. Then we'll add it back to the failover cluster, run cluster validation and add to the AG.

Let me know what you think.