Can I apply SP for SQL Server 2008 R1 on only one node of a cluster?


I need to apply SP2 for SQL Server 2008 R1 on one instance of a multi-instance cluster. I was going to apply the SP on only one node of the cluster. This is because on the other node of the cluster I cannot get the necessary downtime on the other active instances. Although I am not patching these other instances, normally you have to reboot the server/node when applying a SP and they would be affected by the reboot or by failing them over to the other node of the cluster.
I will apply the SP on the other node in future when I can organise the necessary downtime.
conorbrophyAsked:
Who is Participating?
 
Metehan OzculluSQL Service ManagerCommented:
yes you can. do it

you have to remove the passive node from the the sql resource possible owners and apply the servicepack. after doing the service pack add it back again. when you get the downtime, failover the resource to this node and remove the other resource from possible owners. after applying the servicepack to that node also, add it back.

thats all..
0
 
conorbrophyAuthor Commented:
But can I apply the SP on one node of a cluster and NOT apply it on the other node of the cluster for a number of weeks? Are there any implications doing this?
0
 
Metehan OzculluSQL Service ManagerCommented:
this article also tells that:

http://support.microsoft.com/kb/958734/en-us
0
 
Metehan OzculluSQL Service ManagerCommented:
if you apply the servicepack to one node and during the waiting period you failover to patched node due to a reson, you should not failback before you apply the sp. no other problems.
0
 
conorbrophyAuthor Commented:
Didn't fully answer my initial question but information was good and accurate.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.