October 2013 Cumulative Update for SQL Server 2008 R2

SQL Server / SQL Server 2008 R2

October 2013 Cumulative Update for SQL Server 2008 R2

Aaron Bertrand November 12th, 2013 SQL Server / SQL Server 2008 R2 1

Microsoft has released Cumulative Update #9 for SQL Server 2008 R2 Service Pack 2.

KB Article: KB #2887606
17 fixes listed at time of publication
Build number is 10.50.4295
Relevant for @@VERSION 10.50.4000 through 10.50.4294

My usual disclaimer: these updates are NOT for SQL Server 2008 (or SQL Server 2012). Only apply to systems where SELECT @@VERSION returns 10.50.xxxx, where xxxx is >= 4000. If xxxx < 4000, you need to start thinking about getting off the RTM or SP1 branch. Note that no more cumulative updates will be released for SP1, since support ended on October 8, 2013.

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.

Sergio Pacheco says:

November 22, 2013 at 9:50 PM

After applying the CU, Ran 2008R2 BPA and got the following error:
Category: Operation
Source: edited…
Issue: This instance of SQL Server is either missing a fix for a tempdb problem or the required trace flag is not enabled
[ TF 4135 and 4199 not enabled. ]
Impact: The current SQL Server build can result in high severity errors reported for the tempdb database while working with temporary tables
Resolution: Enable Trace Flag 4135 or 4199
I thought this was fixed several CU's ago?
Checked CSS – http://blogs.msdn.com/b/psssql/archive/2010/08/24/why-use-sql-server-2008-r2-bpa-case-1-missing-updates.aspx