Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to add sp to SQL 2005 cluster?

 
   Database Forums (Home) -> Clustering RSS
Next:  Question on using rebind with auto-runstats/auto-..  
Author Message
Clayton Sutton

External


Since: Apr 06, 2005
Posts: 7



(Msg. 1) Posted: Wed Nov 28, 2007 4:58 pm
Post subject: How to add sp to SQL 2005 cluster?
Archived from groups: microsoft>public>sqlserver>clustering, others (more info?)

Hey everyone,

We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.

Anyone know of a step-by-step white paper on how to do it in a cluster?


TIA,


Clayton

 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Jason Massie

External


Since: Nov 27, 2007
Posts: 15



(Msg. 2) Posted: Wed Nov 28, 2007 4:58 pm
Post subject: Re: How to add sp to SQL 2005 cluster? [Login to view extended thread Info.]
Archived from groups: microsoft>public>sqlserver>clustering, others (more info?)

It is documented in this help file.

http://go.microsoft.com/fwlink/?LinkId=71757


--
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx

"Clayton Sutton" wrote in message

> Hey everyone,
>
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
>
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
>
> TIA,
>
>
> Clayton
>

 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Clayton Sutton

External


Since: Apr 06, 2005
Posts: 7



(Msg. 3) Posted: Wed Nov 28, 2007 8:58 pm
Post subject: Re: How to add sp to SQL 2005 cluster? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hey Jason,

Thanks for the reply.

So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.

That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.


Clayton


"Jason Massie" wrote in message

> It is documented in this help file.
>
> http://go.microsoft.com/fwlink/?LinkId=71757
>
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>
> "Clayton Sutton" wrote in message
>
>> Hey everyone,
>>
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>>
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>>
>> TIA,
>>
>>
>> Clayton
>>
>
>
 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 4) Posted: Wed Nov 28, 2007 10:32 pm
Post subject: Re: How to add sp to SQL 2005 cluster? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.

Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.

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




"Clayton Sutton" wrote in message

> Hey Jason,
>
> Thanks for the reply.
>
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
>
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
>
> Clayton
>
>
> "Jason Massie" wrote in message
>
>> It is documented in this help file.
>>
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>>
>> "Clayton Sutton" wrote in message
>>
>>> Hey everyone,
>>>
>>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>>> install a service pack for SQL 2005.
>>>
>>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>>
>>>
>>> TIA,
>>>
>>>
>>> Clayton
>>>
>>
>>
>
>
 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Clayton Sutton

External


Since: Apr 06, 2005
Posts: 7



(Msg. 5) Posted: Thu Nov 29, 2007 10:58 pm
Post subject: Re: How to add sp to SQL 2005 cluster? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks everyone for the info.!


Clayton



"Geoff N. Hiten" wrote in message

> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
>
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
>
> "Clayton Sutton" wrote in message
>
>> Hey Jason,
>>
>> Thanks for the reply.
>>
>> So from reading the below link it sounds like I don't have to stop the
>> cluster service or anything. Just put the service pack CD in and go for
>> it.
>>
>> That's not the way it worked when I had to update Exchange 2003 to sp2.
>> I had to pause each node and stop the cluster service before I could
>> install the sp.
>>
>>
>> Clayton
>>
>>
>> "Jason Massie" wrote in message
>>
>>> It is documented in this help file.
>>>
>>> http://go.microsoft.com/fwlink/?LinkId=71757
>>>
>>>
>>> --
>>> Jason Massie
>>> Web: http://statisticsio.com
>>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>>>
>>> "Clayton Sutton" wrote in message
>>>
>>>> Hey everyone,
>>>>
>>>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>>>> install a service pack for SQL 2005.
>>>>
>>>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>>>
>>>>
>>>> TIA,
>>>>
>>>>
>>>> Clayton
>>>>
>>>
>>>
>>
>>
>
 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Knowledgy

External


Since: Jan 03, 2008
Posts: 56



(Msg. 6) Posted: Fri Apr 18, 2008 12:14 am
Post subject: Re: How to add sp to SQL 2005 cluster? [Login to view extended thread Info.]
Archived from groups: microsoft>public>sqlserver>clustering, others (more info?)

go Microsft or the microft developer blogs and you'll find plenty

--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Clayton Sutton" wrote in message

> Hey everyone,
>
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
>
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
>
> TIA,
>
>
> Clayton
>
 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Linchi Shea

External


Since: Mar 03, 2006
Posts: 234



(Msg. 7) Posted: Fri Apr 18, 2008 12:14 am
Post subject: Re: How to add sp to SQL 2005 cluster? [Login to view extended thread Info.]
Archived from groups: microsoft>public>sqlserver>clustering, others (more info?)

Not really that different from applying the service pack on a standalone. You
can just run the SP executable. The setup is cluster aware so it'll figure
out the nodes where the files need to be applied.

Linchi

"Knowledgy" wrote:

> go Microsft or the microft developer blogs and you'll find plenty
>
> --
> Sincerely,
> John K
> Knowledgy Consulting
> http://knowledgy.org/
>
> Atlanta's Business Intelligence and Data Warehouse Experts
>
>
> "Clayton Sutton" wrote in message
>
> > Hey everyone,
> >
> > We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> > install a service pack for SQL 2005.
> >
> > Anyone know of a step-by-step white paper on how to do it in a cluster?
> >
> >
> > TIA,
> >
> >
> > Clayton
> >
>
>
>
 >> Stay informed about: How to add sp to SQL 2005 cluster? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL 2005 Ent. Cluster - Hi, Can we use Majority Node Set to run SQL Clustering. If yes, Can anyone provide me the step by step guide to do this. Thanks Neeraj Mehra

SQL 2005 Cluster Repair - I have a 2 node Windows 2003 SQL 2005 Cluster, node 2 was failing so I evicted it and attempted to rejoin it, when I evicted it the cluster failed, I had to redo the cluster to get it back up, then added the second node, but the SQL server, and tools....

About question of Sql server 2005 cluster. - I am Sql server administrator in a company and I don't have experience of sql server 2005 failedover cluster. Recently my company decides to use cluster to conduct disaster recovery strategy. I want to make a preperation about it, could somebody..

How to move SQL Server 2005 instance from non-clustered to.. - I have two node cluster (active-pasive) and two instances of SQL server 2005 running on that cluster. Default SQL instance was installed as clustered, the second named instance was not installed as clustered. I want to move named instance form..

Multiple IP's (from 2 different networks) on a single SQL .. - Hello there, I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have three NIC's in each server. Each NIC is connected to a different network: 192.168.100.1 is the public NIC 10.0.0.1 is the NIC used for communication betwen the...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]