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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)
ASKER
- 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!