March 5, 2008 at 9:56 am
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.
March 5, 2008 at 10:23 am
no, it will stop the sql service
March 5, 2008 at 10:40 am
If it's at all like other SP installs on a cluster, you patch the cluster, and the cluster "pushes" the updates to both nodes. Thus the need to keep the cluster service running. This means that you don't need to run the install on both nodes (the secondary/passive node gets patched).
Count on there being downtime like was mentioned before, since it will apparently stop and start the service as needed, and you will need to restart the nodes (meaning - at least the failover time as an outage window).
I would advocate just taking the outage during the entire time - nothing worse than a lot of activity going on while you're trying to apply a support pack. One thing you DON't want happening is for the SP install to abort at the wrong time: you could end up with a server missing several critical components, etc...
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply