Hi,
We have two identical servers in an active/passive cluster running
Win2K and SQL2K. We want to upgrade on of the servers in the cluster
with a new machine. Is it possible to remove the passive node and add
the new, more powerful machine to the cluster? This will mean we'll
have two different servers in the cluster. And, if so, have you guys
had to overcome any major technical obstacles to implement this? Will
I need to reinstall SQL Server on both nodes or just the node I'm
adding to the cluster?

Thanks,
Terry

it is possible. Click on the link that says VIEW THIS Presentation

http://support.microsoft.com/default...b;en-us;822250

and White paper on SQL 2000 clustering:
http://www.microsoft.com/SQL/techinf...vercluster.asp

Hina Masud
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
Get Secure! -> http://www.microsoft.com/security


--------------------
-From: wondermutt (AT) sbcglobal (DOT) net (Terry)
-Newsgroups: microsoft.public.sqlserver.clustering
-Subject: Newbie Clustering Question
-Date: 10 Jul 2003 11:52:21 -0700
-Organization: http://groups.google.com/
-Lines: 12
-Message-ID: <6eee4aa9.0307101052.5bdc5ee3 (AT) posting (DOT) google.com>
-NNTP-Posting-Host: 65.120.156.175
-Content-Type: text/plain; charset=ISO-8859-1
-Content-Transfer-Encoding: 8bit
-X-Trace: posting.google.com 1057863142 17983 127.0.0.1 (10 Jul 2003 18:52:22 GMT)
-X-Complaints-To: groups-abuse (AT) google (DOT) com
-NNTP-Posting-Date: 10 Jul 2003 18:52:22 GMT
-Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed 00.sul.t-online.de!t-online.de!news-
spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!postnews1.google.com!
not-for-mail
-Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.clustering:10484
-X-Tomcat-NG: microsoft.public.sqlserver.clustering
-
-Hi,
-We have two identical servers in an active/passive cluster running
-Win2K and SQL2K. We want to upgrade on of the servers in the cluster
-with a new machine. Is it possible to remove the passive node and add
-the new, more powerful machine to the cluster? This will mean we'll
-have two different servers in the cluster. And, if so, have you guys
-had to overcome any major technical obstacles to implement this? Will
-I need to reinstall SQL Server on both nodes or just the node I'm
-adding to the cluster?
-
-Thanks,
-Terry
-