Installing SP4 on 2005 cluster

• lulu_lutz

  SSCrazy

  Points: 2155

  More actions

  May 5, 2011 at 10:26 am

  #389453

  Hi,

  I've only done a service pack install on a few clusters, so I just want to make sure I'm doing it correctly.

  1. Apply to the active node (i have all the boxes checked except the backward compatibility)

  2. Fail the db's over to the inactive node

  3. Apply the patch

  For #3, do I have to upgrade the database again, or is it upgraded from step 1 already?

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  May 5, 2011 at 11:29 am

  #1320585

  Hi,

  I hope that following link can help you:-

  http://troubleshootingsql.com/2010/01/11/quick-facts-about-applying-updates-on-a-sql-cluster/

  regards,

  Ankur

• lulu_lutz

  SSCrazy

  Points: 2155

  More actions

  May 5, 2011 at 11:57 am

  #1320607

  So since the Database Services, Analysis Services are cluster aware, there's not even a need for a failover?

• free_mascot

  One Orange Chip

  Points: 27169

  More actions

  May 6, 2011 at 1:34 am

  #1320822

  That's what above link says.

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."