|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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, Clayton It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757 -- Show quoteJason Massie Web: http://statisticsio.com RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx "Clayton Sutton" <n***@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 Show quote "Jason Massie" <jason**R3mov***@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" <n***@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. -- Show quoteGeoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Clayton Sutton" <n***@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**R3mov***@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" <n***@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 Show quote "Geoff N. Hiten" <SQLCrafts***@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" <n***@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**R3mov***@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" <n***@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 >>>> >>> >>> >> >> >  |
|||||||||||||||||||||||
Other interesting topics