Home Forums SQL Server 2008 SQL Server 2008 High Availability Question on installing new active node in an active-passive cluster configuration after current active node has failed RE: Question on installing new active node in an active-passive cluster configuration after current active node has failed

  • muthyala_51 (2/27/2014)


    Marios Philippopoulos (2/27/2014)


    No, the server itself is unusable; something happened and we are no longer able to even remote-desktop to it.

    It needs to be rebuilt and the SQL re-installed. Problem is this was initially the "active" node in the cluster configuration.

    The SQL instance now resides in the "passive" node, B, but we have no HA for it; if something happens to server B, we have no failover option at the moment.

    So you have all the databases live on the other node which was passive before active server went down. So failover happened to passive node before the active went down, right? If yes, the cluster can be on the single node. Try to work on the other node and fix it. Try to run the remove node from sql installation and then evict the node and start from scratch.

    Correct.

    When you say "start from scratch", do you mean add a fresh new node to the cluster and use the "Add another node" installation option on the new node to install another "passive" node for the FCI?

    I am just not sure about the specifics of what to do once a new node has been added to the cluster (to replace the failed one, which we cannot fix, BTW) and I am ready to install the failover-cluster instance on that new node. Bear in mind, I already have the FCI running on node B.

    __________________________________________________________________________________
    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]