SQL Server Performance Forum – Threads Archive
Migrate to cluster in place
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, DBAUniversity of Wisconsin
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
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.
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.
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
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.
]]>