<div>
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?
</div>


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?

<div>
this article also tells that:<br />
<br />
<a href="http://support.microsoft.com/kb/958734/en-us" rel="ugc">http://support.microsoft.com/kb/958734/en-us</a>
</div>


this article also tells that:

http://support.microsoft.com/kb/958734/en-us [http://support.microsoft.com/kb/958734/en-us]

<div>
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.
</div>


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.

<div>
Didn't fully answer my initial question but information was good and accurate.
</div>


Didn't fully answer my initial question but information was good and accurate.

<div>
<div class="content wysiwyg-content">
<br />
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.<br />
I will apply the SP on the other node in future when I can organise the necessary downtime.
</div>
</div>



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.

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.