How we can install service pack to two node cluster,where one node is Active and Other is Passive.
Please correct me if I am wrong,...first we will install service pack to passive node...restart it,then manual fail over...then install the service pack to another node and resratrt it...
asked Aug 30 '11 at 07:09 AM in Default
You haven't stated which version, but here's the link for 2008 http://support.microsoft.com/kb/958734, which is essentially the same as you have outlined.
If you are on 2005, then there is a different approach as discussed in this article : http://blogs.technet.com/b/mdegre/archive/2010/01/16/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx
answered Aug 30 '11 at 07:15 AM
Kev Riley ♦♦