Hi,
I am presently running Windows 2003 cluster with SQL Server 2000. My
question is what is the correct way to apply Critical Updates to a SQL
Cluster?
Thank you in advance for tour assistance!
Bob

This should help, http://support.microsoft.com/?kbid=811168 it's pretty darn
easy

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Bob Mare" <rmare (AT) wurldmedia (DOT) com> wrote

Thank you for the reply however I am asking how to run Windows Critical
Updates in a SQL clustered environment

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:eHZL9u3tEHA.220 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

Pretty much the same way yo do in a non-clustered environment. I typically
apply the update to an idle node, reboot if necessary, move cluster
resources, repeat as necessary. Of course, it is a good idea to pick low
activity times to shift cluster resources. Sometimes it is necessary to run
host nodes with different elevels of critical updates if you can't move
resources for a while. I have not run into any problems with this.

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

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

"Bob Mare" <rmare (AT) wurldmedia (DOT) com> wrote

Thank you, I was dreading the answer on this question. A little mmore
interaction required that I would have liked to see but easy enough to deal
with.

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Definitely don't allow the host nodes to download and install by themselves.
Somehow a group policy got applied to our MSMQ cluster hosts that told them
to go full automatic on Windows Updates. Of course, both host nodes
downloaded and applied and rebooted at nearly the same time. No working
host until the reboot finished. Sometimes smart technology can do REALLY
dumb things.

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

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

"Bob Mare" <rmare (AT) wurldmedia (DOT) com> wrote

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Gotta love it. I love it when things do exactly what you tell them to do.
Whether or not it's the right thing. :-)