This article describes cumulative update package 9 (Build number: 10.50.4295.0) for Microsoft SQL Server 2008 R2 Service Pack 2 (SP2) . This update contains hotfixes for issues that were fixed after the release of SQL Server 2008 R2 SP2.
How to obtain this cumulative update package
Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
|VSTS bug number||KB article number||Description|
|1525439||2812884||FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2|
|1425474||2823086||FIX: "The MDX function failed because the coordinate for the 'AttributeName' attribute contains a set." message when you run an MDX query in SQL Server 2012 or in SQL Server 2008 R2|
|1449375||2861456||FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 Transactional Replication|
|1396870||2819662||FIX: SQL Server performance issues in NUMA environments|
|1372920||2864930||FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server 2008 R2 BIDS|
|1421163||2875260||FIX: It takes longer than expected to create a filtered statistic after you create a clustered index on a partitioned table in SQL Server 2008 R2|
|1423079||2875949||FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL Server 2008 R2|
|1441849||2878377||FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL Server 2008 R2|
|1436898||2878807||FIX: System.NullReferenceException is thrown when an SSRS 2008 R2 report or subscription is opened in SharePoint integrated mode|
|1451752||2878968||FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008 or in SQL Server 2008 R2|
|1455319||2885565||FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL Server 2008 R2|
|1516287||2889492||You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1|
|1432961||2889987||FIX: "Invalid column name '<ColumnName>'" error when you run some MDX queries that you could previously run successfully in SQL Server 2008 R2|
|1480939||2890095||FIX: Interrupted distributed query may return partial result set without any error in SQL Server 2008 R2|
|1421519||2890818||FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS 2008 R2|
|1472145||2891230||FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS 2008 R2|
|1342249||2893022||FIX: "Could not redo log record" error and log shipping stops working after an automatic failover in SQL Server 2008 R2|
Notes for this update
Installation and deployment
- We recommend that you test hotfixes before you deploy them in a production environment.
- This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. The updates in this package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for
the next SQL Server 2008 R2 service pack that contains the hotfixes in this package.
Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2008 R2 update release. We recommend that you consider applying
the most recent update release .
the most recent update release .
Cumulative update package information
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2008 R2 SP2.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- How to obtain the latest service pack for SQL Server 2008 R2.
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems.
- Naming schema for Microsoft SQL Server software update packages.
- Description of the standard terminology that is used to describe Microsoft software updates.