New answers tagged availability-groups
0
As there is no formatting in the comment I paste the plan here:
First join one of new sql to the cluster and make it fully in sync, then I would remove one of old node to have it like that:
SQL_OLD1 - primary
SQL_OLD2
SQL_NEW1
Then join the second new and make it in sync:
SQL_OLD1 - primary
SQL_OLD2
SQL_NEW1
SQL_NEW2
At this point you can do failover to ...
3
Since it's all in the same subnet, when you cut over just remove the AG listener from the old cluster and add one with the same name and IP to the new cluster.
There's no need to change the IP addresses of the new nodes to match the IP addresses of the old servers. The App should be connecting to the AG Listener IP only.
So you end up with:
LISTENER : ...
answered Jan 19 at 17:16
David Browne - Microsoft
38.1k3 gold badges40 silver badges85 bronze badges
Top 50 recent answers are included