More Cumulative Updates available for SQL Server 2008
July 22nd, 20094
More Cumulative Updates available for SQL Server 2008
July 22nd, 20094
 
 

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 Article CU6 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
By: Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

4 Responses

  1. AaronBertrand says:

    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.

  2. Cindy says:

    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!

  3. AaronBertrand says:

    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).

  4. Cindy says:

    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?