Applying SP2 to a SQL 2008 Cluster

Last Post 14 Jan 2011 10:47 AM by Markus_SQL. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Markus_SQL
New Member
New Member

--
14 Jan 2011 06:34 AM
I have a SQL2008 64 bit Cluster running SP1 CU6 and I want to apply SP2.  I think this is how I can do it but I want to just verify with someone that has maybe done this.

Apply SP2 to the inactive node not running SQL Server (Node1) which will update the binaries.
Fail over the SQL Server group to the now inactive group and as SQL Server starts it will apply SP2 to the internals of SQL Server like the master db scripts.
Apply Sp2 to Node 2 which is now inactive.
rm
New Member
New Member

--
14 Jan 2011 07:49 AM
Works if you have win2k8 cluster, will update both nodes at same time on win2k3 cluster.
JohnMarks
New Member
New Member

--
14 Jan 2011 08:38 AM
I just did this on a win2008 a/p cluster.  Applied sp 2 to inactive node (node b), failed over and made node b active, applied sp 2 to node a, failed over again.

As far as know for sql server 2008 the update process does not work on more than 1 node at a time like it would with sql server 2005.   I don't think whether you are on windows 2008 or 2003 makes a difference.
Markus_SQL
New Member
New Member

--
14 Jan 2011 10:47 AM
Thanks to both of you.  Yes, it is a Win2008 Cluster, sorry I did not mention that.  If it truely works this way this is a great feature of Win2008/SQL2008 Clustering.
You are not authorized to post a reply.

Acceptable Use Policy