Rolling Upgrade in SQL Server 2008 R2

Last Post 08 Jul 2011 05:37 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy