Results 1 to 5 of 5

Thread: Clustering SQL Server 2000

  1. #1
    Join Date
    Sep 2002
    Location
    Switzerland
    Posts
    14

    Clustering SQL Server 2000

    Environment:
    SQL Server 2000 SP3a on W2K Advanced Server SP4.
    1 IBM Server x440 with FastT700 Storage (Fibre Channel)

    We need to buy another IBM Server x440 or x445 and we would like to make a cluster.
    Question 1:
    Once we build the Cluster with the installation of the Cluster Service, making the W2K Cluster, is it possible to upgrade the default instance of SQL Server to a default clusterd instance of SQL Server?
    In BOL I have found a note that explain how to do this but I have some doubts.

    When I installed SQL Server I placed the system files on the C: drive, the DB files on our SAN on disk E: and the log files on disk F:.

    Question 2:
    If we would like to use Windows Server 2003 what would be the possibility for an upgrade?
    I mean, should I erase all and start with Windows Server 2003 setup or can you suggest to upgrade the OS first, from W2K Advanced Server, and then cluster SQL Server if possible?


    Can you advice please?
    Any help is really appreciated.
    Thank you very much for your time.
    Franco

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    You have to reinstall sql on cluster since sql instance on cluster needs its own name and ip address. By the way, you need sql2k enterprise edition to install on cluster.

    You can upgrade win2k to win2k3, but don't install terminal service since sql2k cluster installation doesn't work with win2k3's terminal service..

  4. #4
    Join Date
    Sep 2002
    Location
    Switzerland
    Posts
    14

    clustering sql server 2000

    Thank you for your answer.
    When I install w2k3 ,terminal service are installed by default I think.
    Where can I found some more documentation about RMiao's sentence?
    Kind regards.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Refer to Microsoft sql bug number 351768 and 399668.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •