Can someone direct me to a Microsoft article or possibly a SQL Server Central article showing the suggested process to install a Windows Service Pack on a multi node SQL Server Cluster? Our three node cluster is running Windows Server 2008 SP1 with 8 SQL Server 2008 Instances, and we'd like to install Win Server 2008 SP2 on each Node. Also MS DTC is on Node 1.
We have 4 Instances active on Node 1, 4 instances on Node 2, and Node 3 is passive only. My thought is to Pause Node 3 and install SP3, when it's back up move what's on Node 1 to Node 3 then pause the cluster on Node 1 and update it. And finally do the same thing to Node 2 moving what it has back to Node 1.
Is this feasible or is there some other way to do this?