Installing Service Pack on Active/Pasive Cluster Windows 2008 SQL Server 2008

Hi all,

This is really interesting to learn how to apply service pack on Windows 2008 SQL Server 2008 Active/Pasive Clustered environment.

Here we are following the method of applying Service pack on Pasive node first and move the resources to the active node and once service pack is applied on Pasive node do the vice versa. Follow the below notes and link to watch the video. 

Please click the links to watch the videos.

SP on Active/Pasvie Cluster 1
SP on Active/Pasive cluster 2


I have the below notes from the video, it will be helpful.

Before you go further please take a note of the Version on the SQL Server it will change once you apply Service pack. So in-order to verify the installation make a note of the version.
node#1 active
node#2 passive(install on passive node first)

1-  In cluster manager - right click sql server network cluster name - properties - advanced - then uncheck the     passive node#2(this is because we dont want it to fail to this node during the install since it can corrupt binaries)
2- install SP on passive node#2 (make sure sql services stopped on this node, etc)
3- once installed  manual failover services from node 1 to node 2 and update SP on node 1
 steps: A- SQLserver network cluster name advanced and re-select node 2 to add it back in. 
        B- In Cluster Manager move services(current owner)over to node#2 (now that its been patched)   
        C- Now remove node#1 by right clicking  sql server network cluster name - properties - advanced then uncheck node#1
4- install SP 1 on node#1
5- After install complets on node#1 we need to set owners again. Right click sqlserver network cluster name properties  - advanced and re-select node#1 to add it back in.
6- Fail services back to primary node and start services.

Before moving the resources between the nodes open SSMS and verify that the service pack has been applied.

-- David M and Pramod K