Apply SP3 on SQL Server 2005 cluster environment

Posted on 2009-02-12
Last Modified: 2012-05-06
Does it need downtime to apply SP3 on SQL Server 2005 cluster environment?
Is it need install SP3 on both nodes of SQL Server 2005 cluster environment?
Do we need to restart SQL Server Agent or any SQL Server services after SP3 applied?
Question by:luyan
    LVL 51

    Accepted Solution

    Applying service packs on a cluster is a bit of a pain.  You have to install it on the primary node first and restart the failover node after it's installed.  If it's an Active/Active cluster some people recommend you move both active instances to one server, then install the SP on that server.

    Author Comment

    We have Active/Passive cluster. We call Node A - Active and Node B - Passive.So I can
    - Applying SP3 on Node A
    - Failing over from Node A to Node B
    - Reboot Node A
    - Applying SP3 on Node B
    - Failing over from Node B to Node A
    - Reboot Node B
    Please correct me if something wrong.
    LVL 51

    Expert Comment

    If you are Active/Passive then apply SP3 to Node A and follow the prompts.  You don't need to apply SP3 to Node B, it will happen automatically.  (That's described on the web)

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    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…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now