How to add sp to SQL 2005 cluster?

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,
ClaytonIt 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" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> 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
>|||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" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> 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" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> 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
>|||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" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
> 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" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> 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" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> 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
>>
>|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> 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" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
>> 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" <jason**R3move**@.statisticsio.com> wrote in message
>> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> 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" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> 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
>>
>>
>|||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" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> 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
>|||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" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> > 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
> >
>
>