Cluster with 1 server ok second not

#1

Hi all,

The problem that we have:

We have a SQL cluster which contains 2 windows Adv servers, server X and Y
Y is the primary node, and on that node is a virtual SQL installed, X is the
secondary node, but it needs to be reïnstalled,
as there is a db running on the cluster, I wonder if it would have impact as
our db needs to stay online and how I need to do that?

Do I need to evict the second node and then reïnstall it, or just reïnstall
it?
Do I need to install the virtual SQL also on the second node or not?

#2

Look in BOL for the topic 'Maintaining a failover cluster'. It has step by
step instructions on how to add a node to a running cluster. FYI, it can be
done without stopping the running instance.

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

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

"Colemont Bert" <colemont.bert (AT) pi (DOT) be> wrote

Quote:

Hi all,

The problem that we have:

We have a SQL cluster which contains 2 windows Adv servers, server X and Y
Y is the primary node, and on that node is a virtual SQL installed, X is
the
secondary node, but it needs to be reïnstalled,
as there is a db running on the cluster, I wonder if it would have impact
as
our db needs to stay online and how I need to do that?

Do I need to evict the second node and then reïnstall it, or just
reïnstall
it?
Do I need to install the virtual SQL also on the second node or not?

#3

Just be sure that you follow the BOL instructions BEFORE evicting the node
at the Windows level. And after you follow the BOL instructions to add the
node back (assuming you do so) apply the latest service pack/hotfix because
adding a node puts back the RTM version on the new node.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

#4

It Depends.

The initial service pack or hotfix installation should be done at the node
that owns the resource. This will update all binaries and the share data
files. If you replace a node, you need to update the local binaries only.
That is when you run the installation from that node when it does NOT own
any group resources. The service pack installer will update the local
binaries only. This information is in the readme file for each service
pack.

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

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

"Samm" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

When you apply the latest service pack/hotfix, does it require a down
time? My understanding is applying SQL sp/hotfixes, you run it on a virtual

server, not at individual nodes.

Quote:

----- Cindy Gross (MSFT) wrote: -----

Just be sure that you follow the BOL instructions BEFORE evicting the
node
at the Windows level. And after you follow the BOL instructions to
add the
node back (assuming you do so) apply the latest service pack/hotfix
because
adding a node puts back the RTM version on the new node.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no
rights.

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

Cluster with 1 server ok second not

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

Cluster with 1 server ok second not - 04-22-2004 , 04:28 AM

Re: Cluster with 1 server ok second not - 04-22-2004 , 08:07 AM

Re: Cluster with 1 server ok second not - 04-25-2004 , 11:50 AM

Re: Cluster with 1 server ok second not - 04-27-2004 , 12:07 PM