Rolling Upgrade in SQL Server 2008 R2

Last Post 08 Jul 2011 05:37 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
e90fleet
New Member
New Member

--
07 Jul 2011 04:14 PM

Hi all,

What is the best way to upgrade SQL Server 2008 R2 with the latest CU on a 4 node failover clustering?

Let's say i have active/active 4 node cluster and each node has 1 instance running on it.


One more question for sql 2005:

Is it possible to upgrade sql 2005 from SP3 CU8 to SP4 CU3 directly without installing SP4 first?

Thanks

rm
New Member
New Member

--
08 Jul 2011 05:37 AM
1. pick up any node to start with if all 4 nodes are active, otherwise start with passive node. Then you can failover instance to upgraded node and upgrade rest nodes.
2. have to apply sql2k5 sp4 first.


Acceptable Use Policy
---