Post reply

SQL Server 2008 Nodes recovery

  • January 17, 2012 at 3:11 am

    #266705

    All,

    I have 3 nodes SQL Server 2008 Failover clustering, lets say, A, B and C. A fail over to B, B fail over to C and C fail over to A. The problem is server in Nodes A has been crash, and I has been re-install the server.

    What's should I do to add the new installed server to the cluster? It's evict the nodes from cluster? or remove from cluster? or add as new nodes to cluster?

    Thanks

  • January 17, 2012 at 4:09 am

    #1434484

    Check this.

    http://msdn.microsoft.com/en-us/library/ms191545.aspx

  • January 17, 2012 at 4:20 am

    #1434490

    Hi,

    I has been reading it before, the problem is, when I want to remove from the setup wizard, I can't choose the nodes, because the nodes has been already shutdown

  • January 17, 2012 at 6:31 am

    #1434563

    Just to Clarify:

    You have Windows Node A, which hosts SQL instances 1 and 2

    You have Windows Node B, which hosts SQL instances 3 and 4

    You have Windows Node C, which hosts SQL instances 5 and 6

    Node A has failed, so you now have:

    You have Windows Node B, which hosts SQL instances 1 and 2 and 3 and 4

    You have Windows Node C, which hosts SQL instances 5 and 6

    If Nodes B+C are still up and running, then just add the new Node into the existing cluster and then do the SQL 'Add node to existing failover cluster' install.

    Or are you saying that you've also lost nodes B+C, or that you've shut them down?

    blog | napalmgram@Twitter

    Training cats makes SQL Server look easy

  • January 17, 2012 at 6:12 pm

    #1434936

    stuart@leaf-node (1/17/2012)

    Just to Clarify:

    You have Windows Node A, which hosts SQL instances 1 and 2

    You have Windows Node B, which hosts SQL instances 3 and 4

    You have Windows Node C, which hosts SQL instances 5 and 6

    Node A has failed, so you now have:

    You have Windows Node B, which hosts SQL instances 1 and 2 and 3 and 4

    You have Windows Node C, which hosts SQL instances 5 and 6

    If Nodes B+C are still up and running, then just add the new Node into the existing cluster and then do the SQL 'Add node to existing failover cluster' install.

    Or are you saying that you've also lost nodes B+C, or that you've shut them down?

    Node A, host SQL instances 1 and 2

    Node B, host SQL instances 2 and 3

    Node C, host SQL instances 3 and 1

    Current condition is, Node 2 and Node 3 still running, and Node 1 has been move to Node 2.

    Node 1 has been re-install (OS, etc), and the name of the server has been change. The Node 1 still listed in the Cluster Management, but error sign (stop)

    My questions is, how to add back the nodes 1 to the cluster, with that's condition?

    If I add new nodes, it's mean I add a new nodes, not replacing the old one

  • January 18, 2012 at 1:59 am

    #1435040

    Just evict the old 'node' record, and then add the reinstalled node.

    Don't try replacing the old node as that will only cause confusion later on.

    blog | napalmgram@Twitter

    Training cats makes SQL Server look easy

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply