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. JeremyInNC

    Russ Kaufmann [MVP] Guest

    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. JeremyInNC

    Russ Kaufmann [MVP] Guest

    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.
Similar Threads

  1. Copy data from SQL2k to 2005Express DB

  2. Win 2K3 server + apps vs. Win 2K3 SBS Premium...

  3. Help on Updgrading win2k clust to win2k3

  4. how do you write an install that works across all nodes of a clust

  5. cscript prndrvr.vbs doesn't work with Windows 2003 server in clust

  6. question about procedure to add SAN storage to existing 2003 clust

  7. migration from win2k with SQL2k to sbs2k3

  8. FRS on Win Serv 2K3 R2 and Win Serv 2k3 R2 x64

Loading...