Freigeben über

SQL Server 2008 R2 SP2 Is Now Available!

  • Artikel

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:  

Comments

  • Anonymous
    July 26, 2012
    Hi Abhishek, Is it safe to apply SP2 on DB that it using for SAP? Thanks

  • Anonymous
    July 26, 2012
    Hello Piyawat, Yes, SQL 2008 R2 SP2 is fully supported by SAP thanks

  • Anonymous
    July 26, 2012
    Hi Abhishek, will the CU1 for R2 SP2 be available soon? Cheers!

  • Anonymous
    July 30, 2012
    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. " Thanks.

  • Anonymous
    July 31, 2012
    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?

  • Anonymous
    August 02, 2012
    Will you also post the pdb files on the public symbol server?

  • Anonymous
    August 12, 2012
    Are we waiting SQL SERVER 2008 R2 CU1 for SP1 CU UPDATE 6 AND CU 7 fixes

  • Anonymous
    January 18, 2013
    How come SP2 is not available through Microsoft Update?

  • Anonymous
    May 23, 2013
    STILL NOT ON WSUS/SUP/CONFIGMGR.  It's June 2013; Product Released Jul 26, 2012. -_- For Reals?!

  • Anonymous
    October 29, 2014
    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

  • Anonymous
    December 01, 2015
    Le dépassement de délai (30000 millisecondes) a été atteint lors de l'attente de la réponse transactionnelle du service MSSQLSERVER