The company wants me to break a two node Active-Active cluster into a standalone with two-instances ASAP!
Therefore, I need to know, what is the steps involved, and please help my understanding,
If I simply failover the Node from A to B, and remove Node A, I essentially have a one-node SQL Cluster. Can and is it recommended to leave it as is? Or, is there something I need to do to remove the "cluster/virtual aspects" of it? Is there a simple way to do this without rebuilding the entire sql servers/instances?
Please answer all the above elements. TIA! URGENT!