all groups > sql server clustering > october 2004 >
You're in the

sql server clustering

group:

SQL Server Cluster


Re: SQL Server Cluster Rodney R. Fournier [MVP]
10/21/2004 9:39:10 AM
sql server clustering:
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

[quoted text, click to view]

SQL Server Cluster Bob Mare
10/21/2004 10:14:11 AM
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

Re: SQL Server Cluster Bob Mare
10/21/2004 10:47:59 AM
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@die.spam.die.nw-america.com> wrote in
message news:eHZL9u3tEHA.220@TK2MSFTNGP15.phx.gbl...
[quoted text, click to view]

Re: SQL Server Cluster Geoff N. Hiten
10/21/2004 10:54:39 AM
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

[quoted text, click to view]

Re: SQL Server Cluster Bob Mare
10/21/2004 11:03:38 AM
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.

[quoted text, click to view]

Re: SQL Server Cluster Geoff N. Hiten
10/21/2004 11:25:51 AM
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

[quoted text, click to view]

Re: SQL Server Cluster Greg D. Moore (Strider)
10/22/2004 12:58:16 AM

[quoted text, click to view]

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

AddThis Social Bookmark Button