Post reply

I have successfully removed SQL Server 2005 from the SQL2 node because of a bad install

  • March 22, 2010 at 2:09 pm

    #231105

    On SQL1, Cluster Administrator SQLCLUSTER Groups shows the SQL Cluster Group (SQL2) with the red offline arrow. All of SQL2 Resources are offline and the owner is SQL1.

    Question 1: How do I get rid of the SQL2 ? Note if there is a way, please disregard Questions 2 and 3.

    Question 2: When I reinstall SQL Server 2005, do I install on SQL1 or SQL2.

    Question 3: At what point do I turn the original SQL2 resources on line?

    For example; Physical Disk and IP Address 1(SQL2).

    Comment/Question 4: Under the original install somehow the TCP/IP ports got corrupted. How can I ensure that the TCP/IP ports of the new node (SQL2B) don’t get corrupted?

    Thank you for your help.

  • March 22, 2010 at 2:44 pm

    #1137847

    Delete each of the resources under the resource group, then delete the resource group itself (right-click, select delete).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • March 22, 2010 at 2:50 pm

    #1137850

    Wayne,

    How do I get rid of the SQL2? Including Cluster Admin, SQL Server Configuration Manager and SQL Server Surface Area Configuration.

  • March 22, 2010 at 3:50 pm

    #1137902

    rkinney-802645 (3/22/2010)

    Wayne,

    How do I get rid of the SQL2? Including Cluster Admin, SQL Server Configuration Manager and SQL Server Surface Area Configuration.

    Cluster Admin is an Administrator tool for managing clusters. You don't want to remove it.

    Is "SQL2" the name of the node, or the name of the cluster group? Earlier, you said

    ... shows the SQL Cluster Group (SQL2)...

    , which I interpretted to be the name of the cluster group, which you then asked in your first question for how to remove.

    Did you remove SQL from the entire cluster? If you did, then SQL Configuration Mgr and Area Configuration should have been removed also.

    To reinstall SQL, fail the cluster over to Node 1, then install SQL from Node 1.

    It looks like you are calling the Nodes and the Cluster groups the same names... this will easily lead to confusion. At this point, I'm not 100% sure on what you are trying to accomplish.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • March 22, 2010 at 3:54 pm

    #1137905

    In follow up to Waynes post, please document the Cluster Names, Node Names, Group names and let us know what they are (so proper advice can be given).

    Also, it would be good to name the Cluster Groups differently than the Nodes. You want to avoid confusion when discussing your servers and documenting the server setups.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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