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 – 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.
Thanks.
@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.
Are CU1 and CU2 for 32-bit platform only? I cannot find any cumulative updates SQL 2008 R2 SP2 64-bit.
David, do you mean this problem?
http://blogs.msdn.com/b/karthick_pk/archive/2012/07/16/the-process-cannot-access-the-file-c-windows-system32-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process.aspx
http://web.archive.org/web/*/http://web.archive.org/web/*/https://connect.microsoft.com/SQLServer/feedback/details/576412/-the-process-cannot-access-the-file-c-windows-syswow64-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process
If so, they stated there that they won't be fixing this problem, so I wouldn't be watching individual CUs waiting for a fix. For now it seems they believe the workaround (rename the file) is a valid fix.If you mean a different problem, can you be more specific?
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.