asked on Upgrading SQL Server 2008 R2 SP1 to SP3 on a cluster is an outage required
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.
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.
Microsoft SQL Server 2008Microsoft SQL ServerWindows Server 2008
Last Comment
Zack
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thank for the information I found two terrific tutorials showing how to do just that:
https://mssqltrek.com/2011/08/11/installing-sql-server-20082008r2-failover-cluster-part7adding-passive-node-to-sql-cluster/
https://mssqltrek.com/2011/08/12/how-to-patch-sql-server-2008-failover-cluster/
Thank you.