SQL Server 2008 R2 Service Pack 2 Available for Download

SQL Server 2008 R2 Service Pack 2 (SP2) is now available for download. 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 contains Cumulative Update 1 to 5 from SQL Server 2008 R2 SP1.

The package can be used to upgrade the following SQL Server 2008 R2 editions:

• SQL Server 2008 R2 Parallel Computing Edition
• SQL Server 2008 R2 Datacenter Edition
• SQL Server 2008 R2 Enterprise Edition and Developer Edition
• SQL Server 2008 R2 Standard Edition
• SQL Server 2008 R2 Web Edition
• SQL Server 2008 R2 Workgroup Edition
• SQL Server 2008 R2 Express Edition

Download SQL Server 2008 R2 SP2
The links in this section correspond to files available for this download. Download the files appropriate for you.

• Readme.htm (15 KB) Download
• SQLServer2008R2SP2-KB2630458-IA64-ENU.exe (337.7 MB) Download
• SQLServer2008R2SP2-KB2630458-x64-ENU.exe (352.5 MB) Download
• SQLServer2008R2SP2-KB2630458-x86-ENU.exe (241.6 MB) Download

List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2:

The issues that are fixed in this service pack.

• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 958983 (KB2719217) Fix: Latch time-out error when you have heap tables and when data compression is enabled in SQL Server 2008 R2 or in SQL Server 2012

KB article 2630458 provides additional information about key fixes in SQL Server 2008 R2 SP2.

For a detailed list of new features and improvements that are included in Microsoft SQL Server 2008 R2 SP2, review the What's New Section in Microsoft SQL Server 2008 R2 SP2 Release Notes.

System requirements:

• Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP
• System Memory: A minimum 1 GB (Recommended 4 GB or more)
• Hard Disk: A minimum of 1 GB of available hard disk space.
• Processors:
  
  • X86: Pentium III-compatible processor or faster (Processor Speed - 1.0 GHz or faster)
  • X64: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support (Processor Speed - 1.0 GHz or faster)
  • IA64: Itanium processor or faster (Processor Speed - 1.0 GHz or faster)

Source: Microsoft SQL Server 2008 R2 Service Pack 2