• AndeT (1/13/2011)


    All -

    I'm trying to find some documentation or any type of information regarding upgrading a 2008 cluster to 2008 R2 - SQL Upgrage only. I've been looking and haven't found much of anything out there. I have an active/active cluster and I'm not sure if I need to fail everything over to one node and perform the upgrades from there. Any information would be greatly appreciated.

    Much the same as any upgrade or patch in sql server, you apply the upgrade to the passive nodes first, once complete you failover the instances to the passive nodes which then upgrade to 2008 R2. You then upgrade the original node which is now passive

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉