SQL Server 2008 R2 SP2 Is Now Available!

Rate This
  • Comments 10

Dear Customers,

Microsoft SQL Server team is pleased to announce the release of SQL Server 2008 R2 Service Pack 2 (SP2). Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our customers, this upgrade is free and doesn’t require an additional service contract.

SQL Server 2008 R2 SP2 contains fixes to issues that have been reported through our customer feedback platforms and Hotfix solution provided in SQL Server 2008 R2 SP1 Cumulative Update 1 thru to Cumulative Update 5. Service Pack 2 also includes supportability enhancements and issues that have been reported through Windows Error Reporting system.

Microsoft SQL Server 2008 R2 SP2 also addresses a few key customer requests:

  • Reporting Services Charts Maybe Zoomed & Cropped
    Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped. To work around the issue some customers set ImageConsolidation to false.
  • Batch Containing Alter Table not Cached
    In certain situations with batch files containing the alter table command, the entire batch file is not cached.
  • Collapsing Cells or Rows, If Hidden Render Incorrectly
    Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed. When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.

Customers are highly encouraged to stay on a supported service pack to ensure they are on the latest and most secure version of SQL Server 2008 R2.  To obtain SQL Server 2008 R2 SP2 with its improved security and supportability please visit the links below:

Thanks to all the customers who downloaded Microsoft SQL Server 2008 R2 SP2 Community Technology Preview (CTP) and provided feedback.

Thank you,

Abhishek Sinha
Program Manager
SQL Server Sustained Engineering

Related Downloads & Documents: 


Leave a Comment
  • Please add 4 and 3 and type the answer here:
  • Post
  • Hi Abhishek,

    Is it safe to apply SP2 on DB that it using for SAP?


  • Hello Piyawat,

    Yes, SQL 2008 R2 SP2 is fully supported by SAP


  • Hi Abhishek,

    will the CU1 for R2 SP2 be available soon?


  • The KB 2630458 mentions a post SQL Server 2008 R2 SP2 CU but I cannot find any information about that one. I cannot find a KB with the builds released after SQL Server 2008 R2 SP2 was released.

    Quote: "Note If you are upgrading from SQL Server 2008 R2 SP1 Cumulative Update 6, you must apply a post-SQL Server 2008 R2 SP2 cumulative update after you upgrade to SQL Server 2008 R2 SP2 to obtain all the fixes. "


  • Getting the following error in SQLSysClrTypes_Cpu64_1.log

    Microsoft SQL Server System CLR Types requires the .NET Framework version 2.0 or 3.0 or 3.5 or 4.0. Ensure that this requirement is fulfilled before installing Microsoft SQL Server System CLR Types.

    Action ended 8:18:59: CA_ErrorPrereqDotNet20Or30Or35Or40. Return value 3.

    BUT, 2.0, 3.0, and 3.5 are all installed.  Any ideas?

  • Will you also post the pdb files on the public symbol server?

  • Are we waiting SQL SERVER 2008 R2 CU1 for SP1 CU UPDATE 6 AND CU 7 fixes

  • How come SP2 is not available through Microsoft Update?

  • STILL NOT ON WSUS/SUP/CONFIGMGR.  It's June 2013; Product Released Jul 26, 2012.


    For Reals?!

  • Hi guys. I have sql 2008 r2 with sp1 and I need to update to sp2. I am getting an error that the shared features were not present in the instance of the server. What causes that error

Page 1 of 1 (10 items)

SQL Server 2008 R2 SP2 Is Now Available!