2012年2月9日星期四

Basic SQL Cluster Question

I am fairly new to administering SQL Server in a cluster environment,
I was kinda confused this morning when I was reading a post where a
individual installed SP2 for SQL 2005 on both the noeds of the
cluster. My understanding was you install the SP2 in just one node and
the cluster service takes care of it. Am I wrong? Do we really need to
install it in both the nodes?
Thanksshub wrote:
> I am fairly new to administering SQL Server in a cluster environment,
> I was kinda confused this morning when I was reading a post where a
> individual installed SP2 for SQL 2005 on both the noeds of the
> cluster. My understanding was you install the SP2 in just one node and
> the cluster service takes care of it. Am I wrong? Do we really need to
> install it in both the nodes?
> Thanks
>
actualy, SP2 instalation does it on other node(s) automaticaly, it just
asks you for a administrator login/password on the other node(s).
Finaly, sp2 instalation asks you for the restart of the node you're
running it on and reminds you to restart other node(s) manualy|||It depends on what you are patching. Some components are cluster-aware and
update all nodes. Some components require updating on each node
individually.
This blog post covers what goes where.
http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not-to-Cluster-That-SSIS-the-Question.aspx
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"shub" <shubtech@.gmail.com> wrote in message
news:1193403686.136330.93900@.o3g2000hsb.googlegroups.com...
>I am fairly new to administering SQL Server in a cluster environment,
> I was kinda confused this morning when I was reading a post where a
> individual installed SP2 for SQL 2005 on both the noeds of the
> cluster. My understanding was you install the SP2 in just one node and
> the cluster service takes care of it. Am I wrong? Do we really need to
> install it in both the nodes?
> Thanks
>

没有评论:

发表评论