SQLisAwE5OmE (2/4/2014)
Can you share your experience for SP upgrade for SQL 2005 active/passive cluster.I have read that for sql 2005 you do the upgrade to the active node first and when you failover to passive, it gets updated as well. Is this true, please advise.
No you launch the SP installer and it will upgrade all nodes. It should be done within a maintenance window as an outage can be expected
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉