ServicePack Updates on Cluster

• Akkare

  SSCrazy

  Points: 2848

  More actions

  October 27, 2010 at 9:31 am

  #228441

  Hi

  I need help for the below

  Have 2 node sql cluster.what is the procedure to apply service packs and other updates on sql.

  Kindly explain detail.Also explain applying SPs for for replication servers.

  Akkare

• Anam Verma

  SSCertifiable

  Points: 5365

  More actions

  October 27, 2010 at 6:29 pm

  #1243252

  Akkare (10/27/2010)

  ---

  Hi

  I need help for the below

  Have 2 node sql cluster.what is the procedure to apply service packs and other updates on sql.

  Kindly explain detail.Also explain applying SPs for for replication servers.

  Akkare

  go google mate, fyi

  http://support.microsoft.com/kb/958734

• WayneS

  SSC Guru

  Points: 95460

  More actions

  October 27, 2010 at 10:56 pm

  #1243330

  Akkare (10/27/2010)

  ---

  Hi

  I need help for the below

  Have 2 node sql cluster.what is the procedure to apply service packs and other updates on sql.

  Kindly explain detail.

  Passive node first. Reboot passive node if necessary. Active node next. If reboot required, fail cluster groups over to passive node, then reboot.

  Also explain applying SPs for for replication servers.

  The version of sql on the distributer must always be greater than or equal to the version of sql on the publisher (which can be the same server as the distributor), which must always be greater than or equal to the version of sql on the subscriber(s). So, distributor first, then publisher, then subscriber(s).

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2