Jun 172013
 

In April and May, Microsoft released cumulative updates for SQL Server 2008 and 2008 R2 (I blogged about them here and here). They are:

BranchOriginal CUBuild #KB ArticleDate Added
SQL Server 2008 SP3CU #1110.00.5840KB #28340482013-05-20
SQL Server 2008 R2 SP1CU #1210.50.2874KB #28287272013-04-15
SQL Server 2008 R2 SP2CU #610.50.4279KB #28301402013-04-15

 
Sometime after that, looks like the next day, both downloads were pulled, allegedly due to an index corruption issue (if you believe the commentary on the Release Services blog post for CU #6) or due to an issue with w3wp.exe (if you believe the label on the hotfix posted directly to the CU #6 article itself). Or perhaps both. At the very least you may see a regression involving index corruption or massive index size deviation when you rebuild a clustered index online and the plan involves a non-clustered index. I don't have a repro handy.

On June 13th, both articles were updated with new versions of the cumulative updates that no longer exhibit this symptom (sound familiar?). And they were updated again June 17th. So if you download today, you'll actually get:

BranchUpdated CUNew Build #KB ArticleDate Updated
SQL Server 2008 SP3CU #1110.00.5841KB #28340482013-06-17
SQL Server 2008 R2 SP1CU #1210.50.2875KB #28287272013-06-17
SQL Server 2008 R2 SP2CU #610.50.4285KB #28301402013-06-17

 
Please check @@VERSION. If it reports 10.00.5840, 10.50.2874 or 10.50.4279, please go re-download and re-apply the relevant cumulative update for your branch. Better yet, if you're on 2008 R2, please see my post where I announce new CUs for the 2008 R2 branches:

BranchCUBuild #KB ArticleDate Added
SQL Server 2008 R2 SP1CU #1310.50.2876KB #28557922013-06-17
SQL Server 2008 R2 SP2CU #710.50.4286KB #28440902013-06-17

 
In cases like this, I really, really, really wish they would release a new, out-of-band cumulative update (this is a non-issue, now, for R2, but remains an issue for 2008 SP3 customers for another month or so). How many people go back and take another look at the CU article once they have downloaded, installed, and regression tested? Does everyone regression test a full set of online rebuilds, an operation that probably doesn't occur that often? I think many users will simply not see this update and are on the verge of experiencing the symptom – there simply isn't enough visibility when they quietly swap out the versions that the download links yield.

[Cross-posted on sqlblog.com]

  4 Responses to “Attention users running SQL Server 2008 and SQL Server 2008 R2”

  1. This situation still seems to be in some flux, at least for SQL Server 2008 R2.

    The build list KB: "The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released" (http://support.microsoft.com/kb/2730301) currently shows 10.5.4279 for CU6 and 10.5.4286 for CU7.

    The build list KB: "The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released" (http://support.microsoft.com/kb/2567616) currently shows 10.5.2874 for CU12 and 10.5.2876 for CU13.

    It could be that Microsoft has not updated these build list KBs yet, or maybe they are not going to update them.

    • Thanks Glenn, I guess the new CUs got released just in time (though 2008 users are still kind of on their own). I suspect they'll update those KBs when the dust has settled.

  2. They just released (30th August) the CU8 (http://support.microsoft.com/kb/2871401)

    Once you need to give them your email to request the download couldn't they just email you an alert if you should download a new version? I agree with Aaron few people will recheck the old KBs to see if there were any update on the binaries.

    This blog http://sqlserverbuilds.blogspot.in/ can help us to check any updates there was where I first knew about this issue with CU6.

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" cssfile="">