none
SQL Add Cluster Node RRS feed

  • Question

  • Hi

    Windows 2008/SQL 2008 Cluster

    We have evicted a Node from our cluster using Failover Cluster Management

    Nothing was removed/uninstalled from the Node - It just hasn't been in use

    We want to add the Node back into the cluster

    What need to be done from a Windows/SQL point?

    What is the process of adding the Node back into the cluster?

     

    Does SQL need to be reinstalled or can I just introduce the node back into the Cluster

     

    Thanks

     

    Derek

    Monday, October 31, 2011 9:57 AM

Answers

  • Ok, So am I correct in this?

    > Present Shared storage to new Node

    > Add Node in Failover Cluster management.

    > Add Node to Possible owners list in cluster mamagement.

     

    Thanks

     

    Derek

    Perfect!

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    • Marked as answer by Stephanie Lv Monday, November 7, 2011 9:32 AM
    Monday, October 31, 2011 1:00 PM
    Moderator

All replies

  • Did you try addnode operation from SQL Server Installation center?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Monday, October 31, 2011 11:37 AM
    Moderator
  • No - Nothing has been done as yet

     

    I'm trying to find out what the process of bringing the node back into the cluster is.

     

    Do I "need" to run the add node feature from the installation center? Or can I just introduce the node back into the cluster via Failover Cluster Management.

    Bear in mind that nothing was done to the eviected node at all...

     

    When we evicted the node, we just evicted it from Failover Cluster Management - We did nothing else.

     

    Any Ideas?

     

    Thanks

    Monday, October 31, 2011 11:47 AM
  • You need to add back the node in failover cluster manager first. If all binaries are intact, you can add new node as possible owners and test failover.

    I don't have Lab cluster ready to test but it should work.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Monday, October 31, 2011 11:49 AM
    Moderator
  • Thanks

     

    Would I need to present the shared storage to the node again?

     

    Thanks

     

    Derek

    Monday, October 31, 2011 12:00 PM
  • Yes. you need to present shared drive to new node.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Monday, October 31, 2011 12:40 PM
    Moderator
  • Ok, So am I correct in this?

    > Present Shared storage to new Node

    > Add Node in Failover Cluster management.

    > Add Node to Possible owners list in cluster mamagement.

     

    Thanks

     

    Derek

    Monday, October 31, 2011 12:54 PM
  • Ok, So am I correct in this?

    > Present Shared storage to new Node

    > Add Node in Failover Cluster management.

    > Add Node to Possible owners list in cluster mamagement.

     

    Thanks

     

    Derek

    Perfect!

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    • Marked as answer by Stephanie Lv Monday, November 7, 2011 9:32 AM
    Monday, October 31, 2011 1:00 PM
    Moderator