Link to home
Start Free TrialLog in
Avatar of luyan
luyan

asked on

Apply SP3 on SQL Server 2005 cluster environment

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?
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Ted Bouskill
Ted Bouskill
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of luyan
luyan

ASKER

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.
Thanks!
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)