Can I apply SP for SQL Server 2008 R1 on only one node of a cluster?

Posted on 2011-10-12
Medium Priority
Last Modified: 2012-05-12

I need to apply SP2 for SQL Server 2008 R1 on one instance of a multi-instance cluster. I was going to apply the SP on only one node of the cluster. This is because on the other node of the cluster I cannot get the necessary downtime on the other active instances. Although I am not patching these other instances, normally you have to reboot the server/node when applying a SP and they would be affected by the reboot or by failing them over to the other node of the cluster.
I will apply the SP on the other node in future when I can organise the necessary downtime.
Question by:conorbrophy
  • 3
  • 2

Accepted Solution

mozcullu earned 1500 total points
ID: 36956775
yes you can. do it

you have to remove the passive node from the the sql resource possible owners and apply the servicepack. after doing the service pack add it back again. when you get the downtime, failover the resource to this node and remove the other resource from possible owners. after applying the servicepack to that node also, add it back.

thats all..

Author Comment

ID: 36956814
But can I apply the SP on one node of a cluster and NOT apply it on the other node of the cluster for a number of weeks? Are there any implications doing this?

Expert Comment

ID: 36956826
this article also tells that:


Expert Comment

ID: 36956836
if you apply the servicepack to one node and during the waiting period you failover to patched node due to a reson, you should not failback before you apply the sp. no other problems.

Author Closing Comment

ID: 37072867
Didn't fully answer my initial question but information was good and accurate.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Integration Management Part 2
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question