SQLTeam.com | Weblogs | Forums

Move SQL Server AG to new Server

We need to migrate our Windows SQL (2014) Server Always-on Availability Group Cluster to new hardware in the same data center with zero down time. This would be from one VMware Cluster to a new VMware Cluster in the same data center. Is this possible? It is on a Windows 2012 R2 Server.

Thank you...

I think this is really a question for your VMWare team...but, one way to accomplish this would be to add new nodes to the cluster on the new VMWare cluster, add SQL Server to the new nodes and setup the new nodes as secondaries - synchronous.

At cut-over, move the AG to one of the new secondaries making it the primary and move the cluster resources to the new secondary - and migrate the listener. You can then remove the old nodes from the AG and evict them from the cluster.

But again - check with your VMWare team to find out what options they have available.

1 Like