SQL Server Performance

node removed from cluster admin.

Discussion in 'SQL Server Clustering' started by ddbb, Nov 5, 2003.

  1. ddbb New Member

    Hi,<br /><br />I have the following problem:<br /><br />Windows admin removed passive SQL Server 2000 cluster node without running SQL Server Setup (he evicted it from Cluster Administrator). He rebuilt it from scratch and join it in the cluster. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />!] [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />I'm now supposed to add it as a new node. I'm not sure how will the SQL Server react on the fact that the node was not removed properly and I don't have test environment to test this scenario. <br /><br />ANY SIMILAR EXPERIENCE PLEASE?<br /><br />Thanks....
  2. satya Moderator

    Any errors & indication in SQL error log & event viewer log?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. ddbb New Member

    Unfortunately I won't be in the position to check the server till tomorrow.
    What approach would you suggest if there is no test environment?

    Thanks for your help.

  4. satya Moderator

    It depends on how SQL reacts and errors?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. ddbb New Member

    Active node is on and working just fine. The problem is how will that node react on the SQL Setup in attempt to add new node (having in mind that 'new' node wasn't removed previously with the same setup).

    Any idea?

Share This Page