Applying SQL 2000 SP

#31

Correct. It doesn't matter whether you have a cluster or not - when you
apply a SQL Server SP, SQL Server is essentially offline.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"Robin9876" <robin9876 (AT) hotmail (DOT) com> wrote

So this would make the SQL Cluster unavailable during applying the SP?

On 5 Jun, 15:16, "Tom Moreau" <t... (AT) dont (DOT) spam.me.cips.ca> wrote:

Quote:

Log onto the node that is running SQL Server. Apply the SP to that
instance
of SQL Server. The SP is cluster aware, so the binaries get installed on
all nodes.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau

"Robin9876" <robin9... (AT) hotmail (DOT) com> wrote in message

news:3fe1e250-6409-4907-a460-ce1c3c3d61f2 (AT) x35g2000hsb (DOT) googlegroups.com...
For a SQL 2000 Clustered Server, what is the process to apply a SQL SP
to the cluster?

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

Applying SQL 2000 SP

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

Re: Applying SQL 2000 SP - 06-06-2008 , 07:31 AM