SQL Server 2008 R2 Cumulative Updates are available

Microsoft has released cumulative updates for SQL Server 2008 R2.

SQL Server 2008 R2 SP1 Cumulative Update #8

  • KB article is http://support.microsoft.com/kb/2723743
  • Build number is 10.50.2822.0
  • There are 20 fixes published as of 2012-08-31
  • This update is relevant for builds between 10.50.2500 and 10.50.2820

Note that the page that lists builds and updates for SP1 doesn't currently agree with the KB article; the KB article shows 10.50.2821 while the build list correctly shows 10.50.2822. The download is certainly 10.50.2822, so only the KB article is wrong.

SQL Server 2008 R2 SP2 Cumulative Update #2

  • KB article is http://support.microsoft.com/kb/2740411
  • Build number is 10.50.4263.0
  • There are 9 fixes published as of 2012-08-31
  • This update is relevant for builds between 10.50.4000 and 10.50.4260

Similarly, the page that lists builds and updates for SP2 also contradicts the KB article; it currently states that the build is 10.50.4263, not 10.50.4261 as the hotfix KB shows. Again, the file agrees with the build list, not the specific KB for this cumulative update.

Note: Some of the fixes in SP1 CU#8 did not make it into SP2 CU#2. Those fixes will be available in SP2 CU#3.

My usual disclaimer: these updates are NOT for SQL Server 2008. Only apply to systems where @@VERSION returns 10.50.xxxx, where xxxx is >= 2500.

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 SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

5 Responses

  1. David Howard says:

    Aaron – yes, that is the problem I was referring to.  I wasn't aware that they were not planning to fix this issue.  Seems odd to me that MS would consider renaming a file before installing a valid fix, but it does work.

  2. AaronBertrand says:

    @Julia, did you click the link that says "Show hotfixes for all platforms and languages"? My guess is you visited the page from a machine running x86, and for some bizarre reason they assume you should be surfing the web from your servers. They make you hunt and peck to find all versions to "save" you from trying to install the wrong platform on the current machine.

  3. Julia says:

    Are CU1 and CU2 for 32-bit platform only? I cannot find any cumulative updates SQL 2008 R2 SP2 64-bit.

  4. David Howard says:

    Still has the problem with perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll that was in SP2 CU1 & SP1 CU7, thought they would have fixed it in this CU.