service pack on cluster

• santhosh411

  Ten Centuries

  Points: 1155

  More actions

  July 16, 2013 at 3:55 am

  #277428

  I have 2node cluster and when we are applying the service pack on passive node suddenly active cluster was down and it failed over to passive.

  Will SQL instance failover?

  If it is Can you please tell me will that service pack applied to my sql instance?

  Please tell me the best way to ptach on sql cluster?

  Thanks,

  Santosh.

• Perry Whittle

  SSC Guru

  Points: 233901

  More actions

  July 16, 2013 at 4:21 am

  #1632805

  This link details rolling upgrades on sql server 2008.

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

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

• SQLAssAS

  SSCertifiable

  Points: 7246

  More actions

  July 16, 2013 at 8:57 am

  #1632899

  I would always

  1) pause the passive node

  2) run the service pack on the passive node

  3) fail the sql instance to the passive node and test

  4) if test is successful, run the service pack on the active node (Now passive)

  5) fail the sql instance back to the origional node and test

  This will make sure the service pack doesnt do both nodes at the same time leaving you with issues reverting.