SQL Server 2008 R2 Build Versions


April 12, 2010 (Updated: Jun 18, 2013)

Introduction

One of the most important job responsibilities of a Database Administrator is to make sure that SQL Servers within the organizations are applied with the latest security patches, cumulative updates and services packs which are released by Microsoft. However, it is always challenging to keep track of all the security patches, cumulative updates released by Microsoft. In this article I have compiled an exhaustive list of all the security patches, cumulative updates and service packs for SQL Server 2008 R2 Build Versions released by Microsoft.

For information on Cumulative Updates, Security Patches,  and Services Packs of previous SQL Server Versions, follow the links given below:

It is recommend that you to read the article titled "How to Install a SQL Server 2008 Service Pack" to know more about the Best Practices to follow before installing a SQL Server Service Pack or a Cummulative Update for SQL Server.

Indentifying SQL Server Version

Database Administrators can determine the version of SQL Server they are running by executing the below query.

SELECT
 	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel,
	SERVERPROPERTY('Edition') AS Edition
GO

ProductVersion ProductLevel Edition
10.50.1600.1 RTM Developer Edition

The Product Version 10.50.1600.1 represents SQL Server 2008 R2 RTM.



SQL Server 2008 R2 Build Versions

Click the respective description to get the link to download Cummulative Update, Hotfix or Service Pack of SQL Server 2008 R2.

Build KB Description Release Date
10.50.4286.0 KB2844090  Cumulative Update Package 7 for SQL Server 2008 R2 Service Pack 2  Jun 17, 2013
10.50.4279.0 KB2830140  Cumulative Update Package 6 for SQL Server 2008 R2 Service Pack 2  Apr 15, 2013
10.50.4276.0 KB2797460  Cumulative Update Package 5 for SQL Server 2008 R2 Service Pack 2  Feb 18, 2013
10.50.4270.0 KB2777358  Cumulative Update Package 4 for SQL Server 2008 R2 Service Pack 2  Dec 17, 2012
10.50.4266.0 KB2754552  Cumulative Update Package 3 for SQL Server 2008 R2 Service Pack 2  Oct 15, 2012
10.50.4263.0 KB2740411  Cumulative Update Package 2 for SQL Server 2008 R2 Service Pack 2  Aug 31, 2012
10.50.4260.0 KB2720425  Cumulative Update Package 1 for SQL Server 2008 R2 Service Pack 2  July 24, 2012
10.50.4000.0 KB2630458  SQL Server 2008 R2 Service Pack 2 (SP2)   Jul 26, 2012
10.50.2876.0 KB2855792  Cumulative Update Package 13 for SQL Server 2008 R2 Service Pack 1  Jun 17, 2013
10.50.2875.0 KB2828727  Cumulative Update Package 12 for SQL Server 2008 R2 Service Pack 1  Apr 15, 2013
10.50.2874.0 KB2828727  There was an issue with this build upgrade as soon as possible to 10.50.2875.0  Apr 15, 2013
10.50.2869.0 KB2812683  Cumulative Update Package 11 for SQL Server 2008 R2 Service Pack 1  Feb 18, 2013
10.50.2868.0 KB2783135  Cumulative Update Package 10 for SQL Server 2008 R2 Service Pack 1  Dec 17, 2012
10.50.2866.0 KB2756574  Cumulative Update Package 9 for SQL Server 2008 R2 Service Pack 1  Oct 15, 2012
10.50.2822.0 KB2723743  Cumulative Update Package 8 for SQL Server 2008 R2 Service Pack 1  Aug 31, 2012
10.50.2817.0 KB2703282  Cumulative Update Package 7 for SQL Server 2008 R2 Service Pack 1   Jun 18, 2012
10.50.2811.0 KB2679367  Cumulative Update Package 6 for SQL Server 2008 R2 Service Pack 1   Apr 16, 2012
10.50.2806.0 KB2659694  Cumulative Update Package 5 for SQL Server 2008 R2 Service Pack 1   Feb 20, 2012
10.50.2796.0 KB2633146  Cumulative Update Package 4 for SQL Server 2008 R2 Service Pack 1  Dec 19, 2011
10.50.2789.0 KB2591748  Cumulative Update Package 3 for SQL Server 2008 R2 Service Pack 1  Oct 17, 2011
10.50.2772.0 KB2567714  Cumulative Update Package 2 for SQL Server 2008 R2 Service Pack 1  Aug 15, 2011
10.50.2769.0 KB2544793  Cumulative Update Package 1 for SQL Server 2008 R2 Service Pack 1  Jul 18, 2011
10.50.2550.0 KB2716440  Security Update for SQL Server 2008 R2 Service Pack 1  Oct 08, 2012
10.50.2500.0 KB2527041  SQL Server 2008 R2 Service Pack 1 (SP1)   Jul 12, 2011
10.50.1817.0 KB2703280  Cumulative Update Package 14 for SQL Server 2008 R2 June 18, 2012
10.50.1815.0 KB2679366  Cumulative Update Package 13 for SQL Server 2008 R2 Apr 16, 2012
10.50.1810.0 KB2659692  Cumulative Update Package 12 for SQL Server 2008 R2   Feb 20, 2012
10.50.1809.0 KB2633145  Cumulative Update Package 11 for SQL Server 2008 R2 Dec 19, 2011
10.50.1807.0 KB2591746  Cumulative Update Package 10 for SQL Server 2008 R2  Oct 17, 2011
10.50.1804.0 KB2567713  Cumulative Update Package 9 for SQL Server 2008 R2 Aug 15, 2011
10.50.1797.0 KB2534352  Cumulative Update Package 8 for SQL Server 2008 R2  Jun 20, 2011
10.50.1777.0 KB2507770  Cumulative Update Package 7 for SQL Server 2008 R2  Apr 18, 2011
10.50.1765.0 KB2489376  Cumulative Update Package 6 for SQL Server 2008 R2 Feb 21, 2011
10.50.1753.0 KB2438347  Cumulative Update Package 5 for SQL Server 2008 R2 Dec 23, 2010
10.50.1746.0 KB2345451  Cumulative Update Package 4 for SQL Server 2008 R2 Oct 18, 2010
10.50.1734.0 KB2261464  Cumulative Update Package 3 for SQL Server 2008 R2 Aug 20, 2010
10.50.1720.0 KB2072493  Cumulative Update Package 2 for SQL Server 2008 R2 Jun 25, 2010
10.50.1702.0 KB981355  Cumulative Update Package 1 for SQL Server 2008 R2 May 18, 2010
10.50.1600.1     SQL Server 2008 R2 RTM Apr 12, 2010

Using XP_MSVER System Stored Procedure

You can also execute the xp_msver inbuilt system stored procedure to know more details related to SQL Server which you are currently running within the organization.

Use master
GO
EXEC xp_msver
GO

EXEC XP_MSVER System Stored Procedure Execution Results in SQL Server 2008 R2


Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article


Geeks who read this article also read…



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."