May 22, 2013 at 2:34 pm
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?
Thanks.
May 27, 2013 at 2:57 am
June 3, 2013 at 2:58 pm
June 4, 2013 at 8:29 am
Since you're talking about Windows service packs rather than upgrading SQL server then I'd suggest following this KB from Microsoft which details how you go through upgrading a cluster with service packs for various versions of Windows.
http://support.microsoft.com/kb/174799
regards
Paul
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply