Data

#1

I am in the planning process of upgrading the hardware on
our cluster. I need info/advice/suggestions on how to go
about this.
I am running an active/active cluster on 2 ML370 servers.
They are running Windows 2000 Advanced Server/SP2, MSSQL
2000 Enterprise/SP2.
I want to know if all I have to do is Failover all
resources from Server2 to Server1, then evict Server2?
Then do all I have to do is run the cluster install? I am
not sure what needs to be done with the SQL instance from
Server2? Do I uninstall it or what? I hope this is clear
enough. Any ideas please let me know.

#2

You will have to ininstall SQL from the node. Treat it as a complete
hardware failure and BOL has step by step instructions.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Viraj" <shethvir (AT) msu (DOT) edu> wrote

Quote:

I am in the planning process of upgrading the hardware on
our cluster. I need info/advice/suggestions on how to go
about this.
I am running an active/active cluster on 2 ML370 servers.
They are running Windows 2000 Advanced Server/SP2, MSSQL
2000 Enterprise/SP2.
I want to know if all I have to do is Failover all
resources from Server2 to Server1, then evict Server2?
Then do all I have to do is run the cluster install? I am
not sure what needs to be done with the SQL instance from
Server2? Do I uninstall it or what? I hope this is clear
enough. Any ideas please let me know.

#3

Hi -
Once you evict server 2, uninstalling or keeping the sql instance
is up to you.
But once you join the server 2 back to the cluster, you need to run the
setup and add server 2 as the possible owner for your sql instance. BOL has
the detailed steps to be done to remove and add the node in a cluster.

Regards,
Chandra
--------------------

Quote:

|Content-Class: urn:content-classes:message
|From: "Viraj" <shethvir (AT) msu (DOT) edu
|Sender: "Viraj" <shethvir (AT) msu (DOT) edu
|Subject: Data
|Date: Sun, 1 Feb 2004 17:53:13 -0800
|Lines: 12
|Message-ID: <7d6f01c3e92f$51762da0$a101280a (AT) phx (DOT) gbl
|MIME-Version: 1.0
|Content-Type: text/plain;
| charset="iso-8859-1"
|Content-Transfer-Encoding: 7bit
|X-Newsreader: Microsoft CDO for Windows 2000
|Thread-Index: AcPpL1F2/FMri/huQxq/7ebmrN1yrg==
|X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
|Newsgroups: microsoft.public.sqlserver.clustering
|Path: cpmsftngxa07.phx.gbl
|Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.clustering:12698
|NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
|X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
|I am in the planning process of upgrading the hardware on
|our cluster. I need info/advice/suggestions on how to go
|about this.
|I am running an active/active cluster on 2 ML370 servers.
|They are running Windows 2000 Advanced Server/SP2, MSSQL
|2000 Enterprise/SP2.
|I want to know if all I have to do is Failover all
|resources from Server2 to Server1, then evict Server2?
|Then do all I have to do is run the cluster install? I am
|not sure what needs to be done with the SQL instance from
|Server2? Do I uninstall it or what? I hope this is clear
|enough. Any ideas please let me know.
|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Data - 02-01-2004 , 07:53 PM

Re: Data - 02-02-2004 , 03:14 PM

RE: Data - 02-04-2004 , 09:49 AM