Perry Whittle (2/27/2014)
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?
We have not done anything yet to fix this.
We have the SQL instance running fine on the passive node B; it had failed over cleanly when node A failed.
Assuming we can get a new server added to the cluster, how should I re-install the SQL on that node?
Use the "Add another node" installation option? Would that work?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]