Upgrading SQL Server 2008 R2 SP1 to SP3 on a cluster is an outage required

Zack
Zack used Ask the Experts™
on
Heyas,

I am running SQL Server 2008 R2 on Vmware Windows Server 2008 R2 cluster (2 node cluster) I want to upgrade the service pack from SP1 to SP3.  My query  twofold is an outage required and if it is can I failover my SQL Server to the second node?

Any advice is appreciated.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
MSSQL Senior Engineer
Distinguished Expert 2017
Commented:
Upgrade first in the passive node. When finished wait for a period with no activity (or less possible activity) in the SQL Server instance and failover it to the passive node. Now the passive become active and you can upgrade the other node.
You can failback the SQL Server instance to his original node after both nodes upgraded. Again, try to perform this operation in a less activity period.
ZackGeneral IT Goto Guy

Author

Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial