[EN] SQL Server 2008 R2 Service Pack 1 Cumulative Update 11 is available

LOGO__SQLServer2008R2Sp1About week ago Microsoft released three packages of Cumulative Updates for SQL Server environment. This is the second post in my short series will I write (in short mode as always) about those packages. 

In this Cumulative Update 11 [version build: 10.50.2869.0] Microsoft resolved only four bugs which could be applied to:

  • Microsoft SQL Server 2008 R2, when used with:
    • Microsoft SQL Server 2008 R2 Analysis Services
    • Microsoft SQL Server 2008 R2 Datacenter
    • Microsoft SQL Server 2008 R2 Developer
    • Microsoft SQL Server 2008 R2 Enterprise
    • Microsoft SQL Server 2008 R2 Express
    • Microsoft SQL Server 2008 R2 Express with Advanced Services
    • Microsoft SQL Server 2008 R2 Reporting Services
    • Microsoft SQL Server 2008 R2 Standard
    • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
    • Microsoft SQL Server 2008 R2 Web
    • Microsoft SQL Server 2008 R2 Workgroup
    • Microsoft SQL Server 2008 R2 Parallel Data Warehouse

Here is the list of resolved bugs:

VSTS BUG: 1028302 | 2760981
FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable

VSTS BUG: 1172951 | 2780146
FIX: "Incorrect syntax near ‘IDENTITY_VALUE’" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008

VSTS BUG: 1172947 | 2791745
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008

VSTS BUG: 1167751 | 2802113
FIX: "Failed Assertion = ‘CheckValidInput (wsName, cbName)’" error when you use database mirroring in Microsoft SQL Server 2008 R2

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 11

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for 32-bit and 64-bit and Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2008 R2 | All (Global) | x86 | 2008R2_SP1_PPExcel_CU11_2812683_10_50_2869_x86
  • SQL Server 2008 R2 | All (Global) | x86 | SQLServer2008R2_SP1_CU11_2812683_10_50_2869_x86
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP1_RSShrPnt_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP1_MDS_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP1_PPExcel_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | x64 | SQLServer2008R2_SP1_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | ia64 | SQLServer2008R2_SP1_CU11_2812683_10_50_2869_IA64

Enjoy!