Please click the link below to watch the video from You tube.
SP on Active/Pasive cluster
Addition notes from the Video.
Imagine
node#1 active
node#2 passive(install on passive node first) as per the video.
Open the Cluster Manager
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.
And before you move the resources to Node1 Open Management studio and verify the Service Pack and version. Please make a note of the version before and after installation, that way you can verify that SP has been completed installed.
-Pramod
SP on Active/Pasive cluster
Addition notes from the Video.
Imagine
node#1 active
node#2 passive(install on passive node first) as per the video.
Open the Cluster Manager
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.
And before you move the resources to Node1 Open Management studio and verify the Service Pack and version. Please make a note of the version before and after installation, that way you can verify that SP has been completed installed.
-Pramod
