Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blakmk
Starting Member
45 Posts |
 Posted - 2008-03-05 : 11:59:55
|
| I’m intending to upgrade a Sql 2005 cluster to SP2 GDR2 (3054) from the CTP version of SP2. Is there a way to do this without downtime? the installation guidelines are a bit ambiguous:• Do not stop the cluster service before you run the SP2 Setup program, or while the installation program is running.• Do not end any running processes before you run the SP2 Setup program.• Do not take the SQL Server service off line before you run the SP2 Setup program. The SP2 Setup program will stop and start the SQL Server service.• Run the SP2 Setup program on the primary node of the failover cluster instance.• You must restart all failover cluster nodes after SP2 is finished installing.• Rolling upgrade is not supported for SP2.Its not clear whether installing on the primary node causes the cluser to failover or whether the service pack also needs to be run on a standby node. Im running 64 bit sql server on Windows 2003 server. Active\Passive |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-03-05 : 16:59:52
|
| No, there is no way to avoid downtime.No, you do NOT have to run the service pack on the other node. The service pack will apply fixes to the passive node. This is your downtime because the cluster has to failover the sql resource group to the passive node in order to service pack it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 22:51:40
|
| Yes, have to apply sp on passive node for ssis, client tools and so. And applying sp will not failover cluster. |
|
|
|
|
|
|
install service pack 2 without downtime?