THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

More Cumulative Updates available for SQL Server 2008

Looks like dozens of fixes for SQL Server 2008 have made their way into another cumulative rollup; CU3 for SP1 (build 2723), and CU6 for RTM (build 1812).  You can get them here:

Cumulative Update 3 for SP1:
http://support.microsoft.com/kb/971491

Cumulative Update 6 for RTM:
http://support.microsoft.com/kb/971490

So what are the main differences?  While I won't pretend (like I did last time) that some of the "missing" fixes from a build weren't already in there from a prior cumulative update, and I also won't pretend that I would be motivated in any way to painstakingly go and track them all down, there definitely seem to be some fixes that only made it into one of these builds, and only a handful that made it into both.

KB ArticleCU6 for RTM
10.00.1812
KB #971490
CU3 for SP1
10.00.2723
KB #971491
Both
KB #948567 yes - -
KB #956574 yes - -
KB #967315 yes - -
KB #967522 - yes -
KB #967552 - yes -
KB #968722 yes - -
KB #968740 - yes -
KB #968741 - yes -
KB #968742 - yes -
KB #968834 yes - -
KB #969050 yes yes yes
KB #969357 - yes -
KB #969467 - yes -
KB #969528 yes yes yes
KB #969611 - yes -
KB #969793 - yes -
KB #969844 yes yes yes
KB #969997 - yes -
KB #970014 yes - -
KB #970044 yes - -
KB #970058 yes yes yes
KB #970133 yes - -
KB #970150 - yes -
KB #970160 - yes -
KB #970198 yes - -
KB #970287 - yes -
KB #970399 - yes -
KB #970507 - yes -
KB #970538 - yes -
KB #970551 yes yes yes
KB #970666 - yes -
KB #970713 yes yes yes
KB #970823 yes yes yes
KB #970909 yes yes yes
KB #970966 yes yes yes
KB #971049 - yes -
KB #971051 - yes -
KB #971057 - yes -
KB #971064 - yes -
KB #971068 - yes -
KB #971132 - yes -
KB #971136 yes yes yes
KB #971402 yes yes yes
KB #971640 - yes -
KB #971772 - yes -
KB #971780 yes - -
KB #971914 yes - -
KB #971985 - yes -
KB #972068 - yes -
KB #972197 - yes -
KB #972198 - yes -
KB #972200 - yes -
KB #972201 - yes -
KB #972203 - yes -
KB #972207 - yes -
KB #972261 - yes -
KB #972440 - yes -
KB #972521 - yes -
KB #972650 yes - -
KB #972681 yes yes yes
KB #972759 - yes -
KB #972763 - yes -
KB #972767 yes yes yes
KB #972777 - yes -
KB #972984 - yes -
KB #973200 - yes -
KB #973204 yes - -
KB #973250 - yes -
KB #973257 - yes -
KB #973301 yes yes yes
KB #973302 yes - -
Published Wednesday, July 22, 2009 2:04 AM by AaronBertrand

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Cindy said:

What is the diff between build 2723 and 1812... aside from skipping sp1 install along the way?  Is there a benefit to using one build over the other?

July 27, 2009 1:27 PM
 

AaronBertrand said:

Cindy, you can't apply 2723 unless you first apply SP1, so there is no case where you can "skip" SP1 to get a later build.  However you should note that the builds are nowhere near equivalent.  In many cases a fix is introduced in one branch or the other (RTM vs. SP1) and only later (or sometimes never) ported to the other branch.  These updates are no exception.  I have updated the main body to show the 71 fixes that are shared between these two builds, and how most of them only seem to be in one build or the other (most seem to have targeted SP1; and those that are missing from there might already be there from a previous SP1 CU).

July 27, 2009 2:06 PM
 

Cindy said:

Thanks for the quick reply Aaron.  My team went thru the process of installing SP1 and then the cumulative update 3 for SP1.  I did not go that route, and I wasn't sure how different my build is from theirs.  Seems like the differences are huge, so I am going to blow away my SQL2008 and reinstall to get the same build.  

Thanks again!

July 27, 2009 2:59 PM
 

AaronBertrand said:

Cindy, you shouldn't need to blow away SQL Server 2008.  You should be able to install SP1 on your current instance, then install CU3 for SP1.  At worst case you will miss out on a couple of fixes that were in 1812 but not in 2723, so if you are actively relying on one of those fixes, you'll want to verify whether it is not in 2723 at all or if it was inserted in an earlier CU for SP1.  That should be small if anything, and those fixes will usually return in the next CU.

July 28, 2009 11:00 AM
 

Aaron Bertrand said:

Back on September 21/22, Microsoft released its most recent cumulative updates for SQL Server 2008. For

November 8, 2009 3:18 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement