We help IT Professionals succeed at work.

Installing a SQL 2005 Service Pack on a Cluster without downtime.

brislane
brislane used Ask the Experts™
on
Is it possible to upgrade a SQL 2005 cluster (2 nodes) to a later service pack without any downtime? How would it be done?

Is it as simple as installing it on the passive node, failing over the cluster and installing it on what's now the passive node?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
That is exactly how you do it.
but for further explaination try this link:

http://msdn.microsoft.com/en-us/library/ms191295.aspx
It is not possible to do an in place upgrade with out down time.
Im still saying we cannot do that with out down time. the down time is minimal..

//During the failover cluster upgrade, downtime is limited to failover time and the time that is required for upgrade scripts to run.//