Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installing Windows Service Pack on Cluster - suggested way? Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 2:34 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:53 PM
Points: 204, Visits: 912
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.
Post #1455707
Posted Monday, May 27, 2013 2:57 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
http://www.google.co.in/url?sa=t&rct=j&q=upgrade%20sql%20cluster%20to%202008%20r2%20doc&source=web&cd=4&cad=rja&ved=0CEIQFjAD&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F3%2F0%2FD%2F30DB8D46-8ACF-442A-99A2-0F4CE74AE14D%2FSQL_Server_2008_R2_Upgrade_Technical_Reference_Guide.docx&ei=VR-jUcLHCcT5rAex_IGwAw&usg=AFQjCNFbFN_E9gZKFZbyh6xaenuME_b7rw&bvm=bv.47008514,d.bmk
Post #1457014
Posted Monday, June 3, 2013 2:58 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 5:30 AM
Points: 811, Visits: 1,165

Making it easier for others.

http://www.google.co.in/url?sa=t&rct=j&q=upgrade%20sql%20cluster%20to%202008%20r2%20doc&source=web&cd=4&cad=rja&ved=0CEIQFjAD&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F3%2F0%2FD%2F30DB8D46-8ACF-442A-99A2-0F4CE74AE14D%2FSQL_Server_2008_R2_Upgrade_Technical_Reference_Guide.docx&ei=VR-jUcLHCcT5rAex_IGwAw&usg=AFQjCNFbFN_E9gZKFZbyh6xaenuME_b7rw&bvm=bv.47008514,d.bmk
Post #1459471
Posted Tuesday, June 4, 2013 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 10:59 AM
Points: 2, Visits: 26
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
Post #1459801
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse