I am looking for ideas on how to move
SQL Server 2012(standard) two node cluster installed on
Windows server 2012 standard to other location which is far away from current location. The two locations are of course connected. The source and destination would be exactly same in all terms.
I am aware that the old and good approach would be to create exact same cluster on the destination and then move database by backup restore and then either change SQL server virtual name to old one or make changes in DNS or application to point to new cluster. But we cannot follow this approach because
- The number of such machines are high
- There is no application owner, so we are not sure where exactly changes needs to be done(a bit tricky situation).
- SQL Server cluster does not supports renaming if database is replicated.
The OS on both the locations would be sitting on
Vmware Esxi 5.5. So this is virtual environment. Everything would be exactly same between source and destination.
The cluster has quorum disk as witness not fileshare and shared disks are on SAN.
NOTE: We have luxury of downtime as weekends would be given to us for migration.