SQLBlog.org

archives disclaimers
archives shortcuts bad habits
disclaimers
SQLBlog Home
bad habits
shortcuts
MERGE NOLOCK dates dynamic SQL
splitting SQL Server 2022 how to ask

Cumulative Update #2 for SQL Server 2008 R2 SP1 is available

Aaron Bertrand SQL Server / SQL Server 2008 R2 6

Last night Microsoft has released Cumulative Update #2 for SQL Server 2008 R2 Service Pack 1. The build # is 10.50.2772 and it contains 14 fixes, a few of which are wrong-results bugs or cases of access violations.

You can download the update here:

KB #2567714 : Cumulative update package 2 for SQL Server 2008 R2 Service Pack 1

It was also mentioned on the SQL Server Release Services blog. It seems to be implied that some of these fixes were included in CUs 7 or 8 for RTM but were left out of SP1 and SP1 CU1, but I haven't validated that by performing a diff.

My necessary disclaimer these days: This update is NOT for SQL Server 2008, and it is NOT for SQL Server 2008 R2 RTM.

 

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 Simple Talk, 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. :-)

6 Responses

  1. Peter says:
    August 17, 2011 at 12:09 PM

    Regarding SQL Server 2005 SP4.  Since Mainstream Support has ended, there are nomally only security updates provided in Extended Support with non-security hotfixes available only with the purchase of an "Extended Hotfix Support Agreement". See http://support.microsoft.com/lifecycle/

  2. ALZDBA says:
    August 17, 2011 at 10:00 AM

    Daniel,
    I've had to retry the download a couple of times to get it started. Once downloaded the extract and install went fine.
    Johan

  3. Aaron Bertrand says:
    August 17, 2011 at 2:18 AM

    It did not fail for me, but yes, you're not alone. Thaey're aware of the issue and are working on it. I think some of the servers in the farm are ok, so keep trying (maybe from a different network, as your current IP might be "stuck" to a bad server).

  4. Daniel says:
    August 17, 2011 at 1:56 AM

    Hi Aaron,
    I requested the update, got the e-mail but the link pointing to the .exe file doesn't work. Have you experienced such issue?

  5. AaronBertrand says:
    August 16, 2011 at 6:39 PM

    Gene, sorry I do not have inside information about when the updates are coming out (and if I did, I wouldn't be able to share it anyway :-)). They are *usually* ~60 days apart for each mainline, however 2005 SP4 hasn't had a cumulative update since March. That was CU3; there isn't a CU4 (yet).

  6. Gene says:
    August 16, 2011 at 6:32 PM

    Hi Aaron,
    Do you know if Microsoft will be releasing a patch for SQL Server 2005 SP4 CU4 soon, if at all.  I do not like patching SQL Server with out of band releases like the one WSUS tried to push in June.
    Gene