How to add sp to SQL 2005 cluster?

FAQ

Profile

How to add sp to SQL 2005 cluster?

Database Forums (Home) -> Clustering

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 11:58 am 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?

Jason Massie

External

Since: Nov 27, 2007
Posts: 15

(Msg. 2) Posted: Wed Nov 28, 2007 11:58 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?)

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?

Clayton Sutton

External

Since: Apr 06, 2005
Posts: 7

(Msg. 3) Posted: Wed Nov 28, 2007 3: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?

Geoff N. Hiten

External

Since: Feb 23, 2005
Posts: 443

(Msg. 4) Posted: Wed Nov 28, 2007 5: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?

Clayton Sutton

External

Since: Apr 06, 2005
Posts: 7

(Msg. 5) Posted: Thu Nov 29, 2007 5: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?

Knowledgy

External

Since: Jan 03, 2008
Posts: 56

(Msg. 6) Posted: Thu Apr 17, 2008 8:14 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?)

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?

Linchi Shea

External

Since: Mar 03, 2006
Posts: 234

(Msg. 7) Posted: Thu Apr 17, 2008 8:14 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?)

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?

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