Marios Philippopoulos (2/26/2014)
We have an active-passive cluster with 2 nodes, A and B, hosting a failover-cluster SQL instance (FCI).When first installing the FCI, we first installed it on A and then used the "Add node to cluster" feature to install it on B.
So A was the "active" and B the "passive" node in the cluster configuration of the FCI.
Now A has been corrupted and we need to rebuild the server and re-install the SQL on A.
Should I be using the "Add node to cluster" feature to re-install the SQL on the rebuilt A server?
So my question is:
how do I re-install the SQL failover-cluster instance on a new node that is substituting a failed "ACTIVE" node in a cluster?
Did you evict the node from the cluster or remove it cleanly or did you just shut it down and rebuild it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉