Add an existing SQL 2000 server to an existing Win 2k3/SQL2k Clust

Discussion in 'Clustering' started by JeremyInNC, Feb 28, 2006.

  1. JeremyInNC

    JeremyInNC Guest

    Can I do this? I have a 2 node SQL cluster running Windows 2003, and another
    SQL 2000 server running Windows 2003 (all Enterprise). Can I add the stand
    alone box to my existing cluster, so the passive node can take over for
    either of the active nodes?
     
    JeremyInNC, Feb 28, 2006
    #1
    1. Advertisements

  2. No. You must install SQL to the cluster _after_ the cluster has been created
    and built.
    What you can do is using the proper SQL tools, move the database the
    existing cluster, then rebuild your standalone server and join it to the
    existing cluster and install SQl on it.

    --
    Russ Kaufmann
    MVP - Windows Server - Clustering
    ClusterHelp.com, a Microsoft Certified Gold Partner
    Web http://www.clusterhelp.com
    Blog http://msmvps.com/clusterhelp
     
    Russ Kaufmann [MVP], Feb 28, 2006
    #2
    1. Advertisements

  3. JeremyInNC

    JeremyInNC Guest

    When I do this would I create a 3rd group and assign the resources for it?
     
    JeremyInNC, Mar 1, 2006
    #3
  4. JeremyInNC

    Craig Wilson Guest

    Hi JeremyInNC,

    Are you trying to add a 3rd node to the cluster?

    Cheers

    Craig.
     
    Craig Wilson, Mar 1, 2006
    #4
  5. Why would you think that?

    If you have a group for one SQL instance and a second group for the other
    SQL instance, then you are set. Groups are used to organize resources that
    belong together so that they also failover and run together all the time.

    --
    Russ Kaufmann
    MVP - Windows Server - Clustering
    ClusterHelp.com, a Microsoft Certified Gold Partner
    Web http://www.clusterhelp.com
    Blog http://msmvps.com/clusterhelp
     
    Russ Kaufmann [MVP], Mar 3, 2006
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.