SQL Server 2008 R2 Service Pack 3 release information

Summary

This article contains important information to read before you install Microsoft SQL Server 2008 R2 Service Pack 3 (SP3). It describes how to obtain the service pack, the list of fixes included in the service pack, how to select the correct download based on your currently installed version, and a list of copyright attributions for the product.

Note This article serves as a single source of information for finding all documentation related to this service pack. It includes all the information that you previously used to find in the Release notes and Readme.txt files.

More Information

How to obtain SQL Server 2008 R2 SP3

SQL Server 2008 R2 SP3 is available for download at the SQL Server 2008 R2 SP3 download page. You can download SQL Server 2008 R2 SP3 Feature Pack here.

List of fixes included in SQL Server 2008 R2 SP3

Microsoft SQL Server 2008 R2 service packs are cumulative updates and SQL Server 2008 R2 SP3 upgrades all editions and service levels of SQL Server 2008 R2 to SQL Server 2008 R2 SP3.

This service pack contains fixes from all Cumulative Updates that were released since SP2 for SQL Server 2008 R2. For a full list of fixes from various cumulative updates since SP2, click the following article number to view the article in the Microsoft Knowledge Base.
2730301 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released
In addition to the Cumulative Update fixes, this service pack also includes the following fixes.



VSTS BugKB article numberDescriptionFix area
29769232994310 FIX: Distribution Agent for Oracle subscription fails when you use SQL Server 2008 R2 or SQL Server 2008SQL service
Not applicable2984340 MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014SQL service

Select the correct file to download and install

The SQL Server 2008 R2 SP3 download page contains the system requirements for installing SQL Server 2008 R2 SP3 and basic installation instructions. For additional documentation about how to upgrade installed SQL Server 2008 R2 components with a SQL Server 2008 R2 servicing update, see SQL Server 2008 R2 Servicing Documentation.

For more information about how to install SQL Server 2008 R2, see SQL Server 2008 R2 Installation.

Use the following table to identify the location and name of the file to download based on your currently installed version. The download pages provide system requirements and basic installation instructions.

Version you currently have installedAction you want to takeFile to download and install
A 32-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2Upgrade to the 32-bit version of SQL Server 2008 R2 SP3SQLServer2008R2SP3-KB2979597-x86-ENU.exe
A 32-bit version of SQL Server 2008 R2 RTM Express or SQL Server 2008 R2 SP1 Express or SQL Server 2008 R2 SP3 ExpressUpgrade to the 32-bit version of SQL Server 2008 R2 SP3 Express SQLServer2008R2SP3-KB2979597-x86-ENU.exe
A 32-bit version of only the client and manageability tools for SQL Server 2008 R2 or SQL Server 2008 R2 SP1 (including SQL Server 2008 R2 Management Studio) or SQL Server 2008 R2 SP2 (including SQL Server 2008 R2 Management Studio)Upgrade the client and manageability tools to the 32-bit version of SQL Server 2008 R2 SP3SQLServer2008R2SP3-KB2979597-x86-ENU.exe
A 32-bit version of SQL Server 2008 R2 Management Studio Express or SQL Server 2008 R2 SP1 Management Studio Express or SQL Server 2008 R2 SP2 Management Studio Express Upgrade to the 32-bit version of SQL Server 2008 R2 SP3 Management Studio ExpressSQLServer2008R2SP3-KB2979597-x86-ENU.exe
Both of the following:
  • A 32-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2
  • A 32-bit version of the client and manageability tools (including SQL Server 2008 R2 RTM Management Studio)
Upgrade all products to the 32-bit version of SQL Server 2008 R2 SP3SQLServer2008R2SP3-KB2979597-x86-ENU.exe
A 32-bit version of one or more tools from the Microsoft SQL Server 2008 R2 RTM Feature PackUpgrade the tools to the 32-bit version of Microsoft SQL Server 2008 R2 SP3 Feature PackOne or more files from Microsoft SQL Server 2008 R2 SP3 Feature Pack
No 32-bit installation of SQL Server 2008 R2Install SQL Server 2008 R2 Management Studio including SP3SQLManagementStudio_x86_ENU.exe install the free SQL Server 2008 R2 SP2 Management Studio Express Edition; then, SQLServer2008R2SP3-KB2979597-x86-ENU.exe
A 64-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2 Upgrade to the 64-bit version of SQL Server 2008 R2 SP3SQLServer2008R2SP3-KB2979597-x64-ENU.exe
A 64-bit bit version of SQL Server 2008 R2 RTM Express or SQL Server 2008 R2 SP1 Express or SQL Server 2008 R2 SP2 ExpressUpgrade to the 64-bit version of SQL Server 2008 R2 SP3 SQLServer2008R2SP3-KB2979597-x64-ENU.exe
A 64-bit version of only the client and manageability tools for SQL Server 2008 R2 or SQL Server 2008 R2 SP1 (including SQL Server 2008 R2 Management Studio) or SQL Server 2008 R2 SP2 (including SQL Server 2008 R2 Management Studio)Upgrade the client and manageability tools to the 64-bit version of SQL Server 2008 R2 SP3SQLServer2008R2SP3-KB2979597-x64-ENU.exe
A 64-bit version of SQL Server 2008 R2 Management Studio Express or SQL Server 2008 R2 SP1 Management Studio Express or SQL Server 2008 R2 SP2 Management Studio ExpressUpgrade to the 64-bit version of SQL Server 2008 R2 SP3 Management Studio ExpressSQLServer2008R2SP3-KB2979597-x64-ENU.exe
Both of the following:
  • A 64-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2
  • A 64-bit version of the client and manageability tools (including SQL Server 2008 R2 RTM Management Studio)
Upgrade all products to the 64-bit version of SQL Server 2008 R2 SP3SQLServer2008R2SP3-KB2979597-x64-ENU.exe
A 64-bit version of one or more tools from the Microsoft SQL Server 2008 R2 RTM Feature PackUpgrade the tools to the 64-bit version of Microsoft SQL Server 2008 R2 SP3 Feature PackOne or more files from Microsoft SQL Server 2008 R2 SP3 Feature Pack
No 64-bit installation of SQL Server 2008 R2Install Server 2008 R2 including SP2SQL Server 2008 R2 SP2 – Express Edition and then SQLServer2008R2SP3-KB2979597-x86-ENU.exe
No 64-bit installation of SQL Server 2008 R2 Management StudioInstall SQL Server 2008 R2 Management Studio including SP3SQLManagementStudio_x64_ENU.exe to install the free SQL Server 2008 R2 SP2 Management Studio Express Edition; then, SQLServer2008R2SP3-KB2979597-x86-ENU.exe
Note After you install the service pack, the SQL Service version should be reflected as 10.50.6000.34.
Copyright attributions

References

For more information about how to determine the current SQL Server version and edition, click the following article number to go to the article in the Microsoft Knowledge Base:
321185
How to identify your SQL Server version and edition
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
Properties

Article ID: 2979597 - Last Review: 29 Sep 2014 - Revision: 1

Feedback