New answers tagged

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 : ...


Top 50 recent answers are included