SQL Server Performance

Migrate to cluster in place

Discussion in 'SQL Server Clustering' started by maboss, May 20, 2004.

  1. maboss New Member

    We are in production with a non clustered db server, windows 2003 , and sql server 2000. We'd like to migrate to a clustered configuration using the existing machine and it's twin. What are the steps to do this? Thanks for any suggestions.

    Nina

    Nina Boss, DBA
    University of Wisconsin
  2. bradmcgehee New Member

    While there are several options, here is how I would do it:

    1) Configure the second node of the cluster identically to the first node (hardware, drivers, software, but don't install SQL Server). Be sure all the hardware is on the Microsoft HCL.

    2) Connect the two nodes to the shared array.

    3) Install SQL Server 2003 clustering on both nodes and verify that they work correctly as a cluster.

    4) Detach all of your databases from SQL Server, and move to the array.

    5) Reinstalled SQL Server 2000 SP3 as a cluster on both nodes.

    6) Reattach the databases to SQL Server.

    There are many more steps than this, but this is the big picture. An article would be required to explain it all.



    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. satya Moderator

    Upgrade the existing pre-SQL Server 2000 cluster to a SQL Server 2000 cluster according to the directions in SQL Server 2000 Books Online.

    After you have successfully upgraded SQL Server, install SQL Server 2000 Service Pack 3 or later.
    Upgrade the current MSCS cluster to the Windows Server 2003 Enterprise/Datacenter according to the Windows Server 2003 documentation.

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;329329 information on error message using SQL on Windows 2003.

    And also refer tohttp://www.sql-server-performance.com/articles_clustering_log_shipping.asp Brad's articles in this regard in detail.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. maboss New Member

    Satya,

    We are not currently clustered at all. We are going from a NON cluster Win 2003 , Sql Server 2000 to a cluster... but using the existing machine and another just like it.

    Thanks,
    Nina


    quote:Originally posted by satya

    Upgrade the existing pre-SQL Server 2000 cluster to a SQL Server 2000 cluster according to the directions in SQL Server 2000 Books Online.

    After you have successfully upgraded SQL Server, install SQL Server 2000 Service Pack 3 or later.
    Upgrade the current MSCS cluster to the Windows Server 2003 Enterprise/Datacenter according to the Windows Server 2003 documentation.

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;329329 information on error message using SQL on Windows 2003.

    And also refer tohttp://www.sql-server-performance.com/articles_clustering_log_shipping.asp Brad's articles in this regard in detail.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

    Nina Boss, DBA
    University of Wisconsin
  5. satya Moderator

    Nina
    My reply intended to follow the books online reference to upgrade SQL Server 2000 (pre cluster or non-cluster) to SQL Server 2000 Cluster, as per the defined steps.

    And follow the referred articles for more information on upgrade. Andhttp://support.microsoft.com/default.aspx?kbid=254321 KBA about Cluster Do's and Dont's.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page