We are in the process of moving datacenters so we want to properly failover our Primary server to an Asynchronous Server in our new datacenter so we can drive the existing gear out there. Here is my setup
Datacenter Old SQL01 (Primary) (Current Vote 1) SQL02 (Secondary) (Current Vote 1)
Datacenter New SQL03 (Secondary Asynchronous) (Current Vote 1)
I also have a File Share Witness configured on a domain controller in our Office that both networks can see. So this also has a vote.
On our cut over day we are going to failover our Primary to SQL03 so we can run our system in the New Datacenter while we drive the existing gear out.
Once I failover I need to shut down SQL01 and SQL02, drive them out to new location, change their IP's and bring them online.
Should I remove SQL01 and SQL02 from the availability group first then re-add them once I bring them online at the new location?
Secondly How will this work with my voting seeing I currently have 4 vote and will be going down to 2?
Will this effect the majority vote?