Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Other Technologies / Clustering / July 2005

Tip: Looking for answers? Try searching our database.

Upgrade OS and hardware

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Elmer - 26 Jul 2005 18:21 GMT
Hi,  Our 2 node(active/active) cluster is running on an old machine and
running SQL2000 and W2k.  We wanted to upgrade the hardware and the OS to
W2003.  I am planning to setup the new hardwares with W2003 and SQL2000 and
then moved the resources over to the new servers and then get rid of the old
ones.

My question is, can different OS belong to the same cluster?  Will my plan
work?

Thanks.

--Elmer
Reply to this Message
Rodney R. Fournier [MVP] - 26 Jul 2005 19:05 GMT
Yes! But Windows 2000 Advanced Server clustering only supports 2 nodes
maximum. Windows Server 2003 clusters can be up to 8 nodes :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://msmvps.com/clustering/archive/2005/07/20/58233.aspx NYC class

> Hi,  Our 2 node(active/active) cluster is running on an old machine and
> running SQL2000 and W2k.  We wanted to upgrade the hardware and the OS to
[quoted text clipped - 10 lines]
>
> --Elmer
Reply to this Message
Geoff N. Hiten - 27 Jul 2005 14:45 GMT
Yes.  This can work.  I have done a similar upgrade in the past.

First, upgrade one node in place toWindows 2003.  Make sure you have all the
drivers, etc to do this.  Once you have tested things thoroughly, upgrade
the other node "in place".  Add the new hardware to the cluster and to the
SQL instances.  Finally, remove the old hardware from SQL and the cluster
configuration.

The key is to test carefully and completely before doing anything
irrevocable.  Make sure you use the SQL installation tools to uninstall SQL
before you kick a node out of the cluster and physically remove it.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hi,  Our 2 node(active/active) cluster is running on an old machine and
> running SQL2000 and W2k.  We wanted to upgrade the hardware and the OS to
[quoted text clipped - 10 lines]
>
> --Elmer
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.