

873603 (KB2682488) Fix: Backup operation fails in a SQL Server 2008, in a SQL Server 2008 R2 or in a SQL Server 2012 database after you enable change tracking.901689 (KB2653857) Fix: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version.820756 (KB2588050) Fix: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed.820878 (KB2565683) Fix: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment.820858 (KB2550375) Fix: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 when you run log shipping from many databases to one secondary server.728527 (KB2216456) SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services.

820875 (KB922578) Fix: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2.The issues that are fixed in this service pack. List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2: The links in this section correspond to files available for this download. SQL Server 2008 R2 Enterprise Edition and Developer Edition.SQL Server 2008 R2 Parallel Computing Edition.The package can be used to upgrade the following SQL Server 2008 R2 editions: SQL Server 2008 R2 Service Pack 2 contains Cumulative Update 1 to 5 from SQL Server 2008 R2 SP1. SQL Server 2008 R2 SP2 are cumulative and can be used to upgrade all releases of SQL Server 2008 R2 to Service Pack 2. SQL Server 2008 R2 Service Pack 2 (SP2) is now available for download.
