Post reply

Re-setting up SQL2005 Clustering

  • July 6, 2007 at 2:10 am

    #372691

    Hi,

     

    We have recently lost one of our Cluster Nodes for a 2 node active/passive setup.

    We lost the passive node of a SQL 2005 SP1 install on 2 x windows Server 2003 servers.

    I'm looking at rebuilding the cluster and I am hoping that the rebuild will be as simple as rerunning the install program on the existing cluster node and re-setting up the cluster functionality at the appropriate point.

    Can anyone confirm that? Or is it simple to uninstall SQL completely and reinstall it again from scratch...?

    Thx

  • July 6, 2007 at 2:46 am

    #717611

    1, Remove Node information from SQL Server by running setup from Add/Remove program

    2. Evict node from Windows

    3. Add new node

    4. Add Node to SQL Server (Add/Remove Programe > Change > Maintain....)

     

     

  • July 6, 2007 at 7:55 am

    #717695

    there is a MS article giving step by step instructions. if you do it wrong you will need to rebuild the entire cluster from scratch

  • July 9, 2007 at 12:39 am

    #717933

    Well, that's helpful.

    And the MS article would be...?

  • July 9, 2007 at 4:58 am

    #717974

    Does the active node go offline if you attach a new node to the cluster...?

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

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