Apply service pack 4 on the sql server2005 Fail over cluster (If Active/Active or Active/passive)

• Database admin(DBA)

  SSCertifiable

  Points: 5373

  More actions

  October 17, 2014 at 12:31 am

  #291028

  Hello DBA's,

  How are you?

  How to apply the Service pack 4on the sql server 2005 cluster. Please let me know the process and steps.

  i think first I have to install on Node A then failover the cluster and then do on secondary Node B.please suggest.

  But other or My senior DBA tells,Sp4 apply on Active node(node A) then reboot..thats it,,it reflect to the Passive node(NodeB).Please suggest me if anything wrong. I need your urgent ...

  Thanks & regards,

  DBA

  SQL server DBA

• VastSQL

  SSC-Dedicated

  Points: 36067

  More actions

  October 21, 2014 at 3:55 am

  #1753693

  The way i do is first install SP on Passive node(B) --> reboot it and then failover from active(A) to passive(B)

  Now B is active and A is passive

  Apply Service packs on A and then reboot it , then move the resources back to A.

  For Active\Active

  Failover to any one node eg A and then repeat the above processes and in the end move the resources back to respective nodes.

  While changing Node1 from A to B change the owner likewise Node2 from B and then back.

  Hope you are aware of the pausing part.