Replacing Hardware in SQL 2005 Cluster?

#31

I think you are missing a key element. When you install SQL, you add the
node to the Instance's allowed nodes. You cannot install SQL then join the
cluster or join the virtual instance. If you install SQL outside of the
cluster, you are doing it as a local install only. Patches are applied
cluster-wide which is where the original problem came from.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

<dave_vandenberghe (AT) yahoo (DOT) com> wrote

Quote:

Geoff:

Unfortunately - I'm running 2005 SQL Standard (I remember thinking at
the time "oh - it's only going to be 2 nodes - so standard is fine" :
looking back - I wish I had done the enterpise!

But that aside - should the above process work ok? I took a look at
your blog post - and I want to make sure I understand - is that
patching issue guaranteed to happen if you are running SP2 on SQL2005
(we are) - or is it only if the newly brought up node is not brought
up to SP2 before you add it to the cluster (I haven't went through the
BOL yet and it's been a few months since I did this originally - but I
don't remember if you patch it before or after you cluster(ed) it -
I'm seeming to remember it's after?

Anyways - thanks for your response and any future response(s)!

-Dave

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

Replacing Hardware in SQL 2005 Cluster?

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

Re: Replacing Hardware in SQL 2005 Cluster? - 05-19-2008 , 09:27 AM