Groups | Blog | Home
all groups > sql server clustering > february 2004 >

sql server clustering : Data


Viraj
2/1/2004 5:53:13 PM
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
Geoff N.Hiten
2/2/2004 4:14:10 PM
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

[quoted text, click to view]

chandra NO[at]SPAM online.microsoft.com
2/4/2004 3:49:07 PM
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
--------------------
||Content-Class: urn:content-classes:message
||From: "Viraj" <shethvir@msu.edu>
||Sender: "Viraj" <shethvir@msu.edu>
||Subject: Data
||Date: Sun, 1 Feb 2004 17:53:13 -0800
||Lines: 12
||Message-ID: <7d6f01c3e92f$51762da0$a101280a@phx.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.
||
AddThis Social Bookmark Button