October 11, 2012 at 11:52 am
Hi,
Can anyone tell what are the reasons behind applying service pack on the passive node not on active node ?
Regards,
Sudhakar a.
October 11, 2012 at 12:21 pm
Apply to passive, fail-over from active, make sure it works as intended (should already have been tested in a test environment, but you still need to be absolutely sure on live servers), then apply to what used to be the active node.
Apply to passive first so that if it fails, you aren't taking the active node down. But then apply to the other node after a failover.
Is that what you mean?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 11, 2012 at 12:28 pm
The primary reason of having a cluster is to prevent downtime. If you patch your active node, you are going to cause yourself an outage and a potential failover because patching will stop the services. You should patch the passive node first, fail over to the patched node, then patch your other node. If you have more than two nodes, you will need to do some work in cluster manager first to be sure the unpatched nodes do not become owners before they are patched.
Dana
October 12, 2012 at 7:49 pm
Thanks for your reply.
I agree on the point, apply on the passive node verify whether patch is failing or not and if it does not then apply on anther node after fail over.
It wll allow user's to connect the databases untill we are not making the failover to passive node after patching on it. After fail over on patched node it wont allow any one from that instance since patching is on half way. That's the case then how it could avoid down time of the sql instance ?
October 13, 2012 at 10:26 am
patch the passive node, then failover to it. On failover the patching process for that node is completed as SQL goes into update script mode as it comes up. That node is then fully usable. You could leave it for months before patching the other node(s) if you wanted to (though I wouldn't)
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply