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

Posted on 2011-10-12
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
    LVL 7

    Accepted Solution

    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

    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?
    LVL 7

    Expert Comment

    this article also tells that:
    LVL 7

    Expert Comment

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    SQL Date from a string 4 41
    Need some help wiht :CAST AS Double 11 35
    SQL Server 2008 9 30
    Import csv files to MS SQL 5 35
    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now