Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Patching 2 of 6 instances on 3 node (AAA) SQL 2008 R2 Cluster


Patching 2 of 6 instances on 3 node (AAA) SQL 2008 R2 Cluster

Author
Message
TrailRunner
TrailRunner
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 643
Hi,
Just inherited a 3 node active active active SQL 2K8 R2 cluster. 6 RTM instances, 2 on each node. I am in need to patch SP2 on only 2 of the 6 instances. Currently patching all is not an option. I see that I can pick which ever instance or services to patch during initial selection screen of the SP2 installation, BUT there is also the Shared components (including Integration Services and client connectivity tools) which is checked and grayed out.

Does it mean I have to have SP2 on them regardless of how many instances or services I select for the upgrade? and will it affect the other instances that will still be in RTM?

Also, if I patch (rolling) the passive nodes of the 2 instances I am interested first, do you think a reboot will be required for the passive nodes??

I can test the SP2 on SQL 2008 R2 stand alone server, but just don't have a test cluster that resembles the one I have above...

Appreciate any response...thanks.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8853 Visits: 16589
TrailRunner (2/28/2013)
Hi,
Just inherited a 3 node active active active SQL 2K8 R2 cluster. 6 RTM instances, 2 on each node. I am in need to patch SP2 on only 2 of the 6 instances. Currently patching all is not an option. I see that I can pick which ever instance or services to patch during initial selection screen of the SP2 installation, BUT there is also the Shared components (including Integration Services and client connectivity tools) which is checked and grayed out.

Does it mean I have to have SP2 on them regardless of how many instances or services I select for the upgrade? and will it affect the other instances that will still be in RTM?

The installer will automatically update the client tools if they're installed, wont affect connecting to the RTM instances.


TrailRunner (2/28/2013)
Also, if I patch (rolling) the passive nodes of the 2 instances I am interested first, do you think a reboot will be required for the passive nodes??

Reboot them beforehand to ensure there are no pending reboots, they'll likely want a reboot afterwards too. Since they're passive this doesnt matter.

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
TrailRunner
TrailRunner
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 643
Thank you Perry,
Good to know about the shared features. I am trying to avoid a reboot on passive nodes as I have 6 instances in the cluster. I am referring to a node passive node for the instance I am patching, but the node is active to other instances.

I tried it on a single instance 2 node cluster (Active Passive) yesterday, and it didn't require a reboot. I know this is different than the one I will be working on (Active Active Active). I am hoping that it won't ask a reboot, as I can't. Do you think I can roll it back at that point when a reboot is required at the end?
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8853 Visits: 16589
You don't have to reboot there and then just defer it until you get the opportunity to reboot

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
TrailRunner
TrailRunner
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 643
Thanks again,
If a reboot is indeed required after the update, then I will be for sure running the updated instance on one of the node that is pending a reboot after SQL2008 R2 SP2, will it corrupt anything, will anything bomb? How high a risk am I running?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search