October 2013 Cumulative Update for SQL Server 2008 R2

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, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. In real life I am a father of two, an architect at Wayfair, and my pronouns are he/him.

1 Response

  1. Sergio Pacheco says:

    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