Steps to install SQL Service Pack on SQL2008 Cluster

• Davekahn

  SSCommitted

  Points: 1840

  More actions

  March 2, 2012 at 11:25 am

  #254169

  Hi,

  I need to know the steps to install service pack on Sql Server 2008 R2(RTM) Cluster - (Active/Passive)

  Please confirm the following steps are correct:

  1. Apply the hotfix on pasive node N2

  2. Reboot the passive node N2

  3. Failover on SQL resource : the passive node become the active node

  4. Apply the hotfix on the passive node N1

  5. Reboot the passive node N1

  Dave

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  March 4, 2012 at 3:35 am

  #1454540

  Yes, that would be correct. In future you may want to post in the SQL 2008 forum 😉

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

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

• Davekahn

  SSCommitted

  Points: 1840

  More actions

  March 4, 2012 at 10:51 am

  #1454577

  Ok, thanks