Applying a service pack to cluster

• Summer90

  SSC-Dedicated

  Points: 32891

  More actions

  January 14, 2011 at 7:29 am

  #232954

  I am going to be applying SP2 to a SP1 CU5 production cluster. I believe I have this right but just want verification from anyone that has done this.

  I can apply the SP2 to the inactive node which will update the binaries, once complete fail over the SQL Server node/drives to the inactive node and as SQL Server starts up it will apply SP2 to SQL Server.. IE Master, etc.... Then apply SP2 to the second node which is now inactive.

  This, in effect, will make only a few minutes of an outage as SQL Server doesn't have to be down really for applying SP2.

  Is this correct?

• mazzz

  SSCertifiable

  Points: 6139

  More actions

  January 14, 2011 at 8:02 am

  #1273562

  That's what we do when patching our production cluster

  ------------------------------------------------------------------------
  Bite-sized fiction (with added teeth) [/url]

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  January 16, 2011 at 1:15 am

  #1273961

  you can use the following to update a passive node also from the command line

  SQLServer2008SP2-KB92xxxx-x86-ENU.exe /allinstances /passive=1

  or

  SQLServer2008SP2-KB92xxxx-x86-ENU.exe /instancename = SQLinst1,SQLinst2 /passive=1

  This works for SQL2005 SP2 and above 😉

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

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

• Summer90

  SSC-Dedicated

  Points: 32891

  More actions

  January 18, 2011 at 8:25 am

  #1274762

  Thanks. Just reaffirmed what I already thought.