Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Apply SP3 on SQL Server 2005 cluster environment

Posted on 2009-02-12
Medium Priority
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
  • 2
LVL 51

Accepted Solution

Ted Bouskill earned 1500 total points
ID: 23630472
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

ID: 23634476
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

by:Ted Bouskill
ID: 23636288
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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Backup & Restore 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.
Screencast - Getting to Know the Pipeline
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

575 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