SQL Server 2008 R2 Service Pack 2 Cumulative Update #1 is available

Microsoft has released a cumulative update for SQL Server 2008 R2 SP2, which was only released last week.

  • KB article is http://support.microsoft.com/kb/2720425 
  • Build number is 10.50.4260.0
  • There are 35 fixes published as of 2012-08-01
  • This update is relevant for builds between 10.50.4000 and 10.50.4259

    My recommendation: if you have already installed Service Pack 2, or were waiting on the first cumulative update before doing so, this may be what you've been waiting for. According to the SQL Release Services Blog, SP2 CU#1 includes all of the fixes from SP1 CU#6 and CU#7 (which were not included in SP2 RTM).


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

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.

4 Responses

  1. Aaron Bertrand says:

    mq44944 it seems you are trying to install 2008 R2 SP2 CU1 before installing 2008 R2 SP2. Please install this update first:
    /blogs/aaron_bertrand/archive/2012/07/26/sql-server-2008-r2-service-pack-2-is-available.aspx

  2. mq44944 says:

    When I install the 2008 r2 sp2, there is an error:
    The version of SQL Server instance Shared Component does not match the version expected by the SQL Server update. The installed SQL Server product version is 10.50.1600.1, and the expected SQL Server version is 10.52.4000.0.
    select @@version
    Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
    Do you know why?

  3. Chris Wood says:

    Not really Daniel. They did the same for SP1.SP1 came out July 12 2011 with CU1 out on July 18 2011. MS have more reason to have it out as August is an SQL2008R2 Cumulative Update month. I would expect CU2 later this month along with SP1 CU8, especially if you read the blog http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/08/01/cumulative-update-1-for-sql-server-2008-r2-service-pack-2.aspx
    Chris

  4. Daniel says:

    wow
    that was fast. 5 days for CU#1