SQL Server 2008 R2 Build List

By Steve Jones, 2013/04/19 (first published: 2010/05/25)

This is a list of the builds for SQL Server 2008 R2. This is a separate product than SQL Server 2008. There are other build lists available here.

A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let me know (sjones @ sqlservercentral.com).

All builds are listed in reverse order, so the newest are at the top and the earliest at the bottom. You can find your build number with:

select @@Version

in a query window. This gives you the current version you are running and it should match up with one of the builds listed below.

Major Builds

Build	KB Article	Title	Description
10.50.4000	2630458	Service Pack 2 for SQL Server 2008 R2	The second roll-up of patches into a service pack for SQL Server 2008 R2. Note this IS NOT for SQL Server 2008, only the R2 version.
10.50.2500.0	Service Pack 1	Service Pack 1 for SQL Server 2008 R2	The first roll-up of patches into a service pack for SQL Server 2008 R2. Note this IS NOT for SQL Server 2008, only the R2 version.
10.50.1600	RTM	Release of Manufacturing of SQL Server 2008 R2	The first public, supported version of SQL Server 2008 R2

Note that Service Packs include all builds below that Service Pack level. So any builds listed below Service Pack 1 are included in Service Pack 1. Those below Service Pack 2 (including Service Pack 1), are included in SP2, etc. Hotfixes may or may not include updates below them because there are two trees of code. The cumulative updates do include all hotfixes before them.

You can also download a CSV of the builds attached to this article.

Build	Kb Article	URL	Description
10.50.4279	2830140	http://support.microsoft.com/kb/2830140	CU #6 for SQL Server 2008 R2 SP2
10.50.4276	2797460	http://support.microsoft.com/kb/2797460	CU #5 for SQL Server 2008 R2 SP2
10.50.4270	2777358	http://support.microsoft.com/kb/2777358	CU #4 for SQL Server 2008 R2 SP2
10.50.4266	2754552	http://support.microsoft.com/kb/2754552	CU #3 for SQL Server 2008 R2 SP2
10.50.4263	2467239	http://support.microsoft.com/kb/2467239	CU #2 for SQL Server 2008 R2 SP2
10.50.4260	2720425	http://support.microsoft.com/kb/2720425	CU#1 for SQL Server 2008 R2 SP2
10.50.4000	2630458	support.microsoft.com/kb/2630458	Service Pack 2
10.50.2874	2828727	http://support.microsoft.com/kb/2828727	CU#12 for SQL Server 2008 R2 SP1
10.50.2869	2812683	http://support.microsoft.com/kb/2812683	CU#11 for SQL Server 2008 R2 SP1
10.50.2868	2783135	http://support.microsoft.com/kb/2783135	CU#10 for SQL Server 2008 R2 SP1
10.50.2866	2756574	http://support.microsoft.com/kb/2756574	CU#9 for SQL Server 2008 R2 SP1
10.50.2761	MS12-070	http://technet.microsoft.com/en-us/security/bulletin/ms12-070	Microsoft Security Bulletin MS12-070
10.50.2822	2567616	support.microsoft.com/kb/2567616	CU#8 for SQL Server 2008 R2 SP1
10.50.2817	2703282	http://support.microsoft.com/kb/2703282	CU #7 for SQL Server 2008 R2 SP1
10.50.2811	2679367	http://support.microsoft.com/kb/2679367/	CU#6 for SQL Server 2008 R2 SP1
10.50.2807	2675522	http://support.microsoft.com/kb/2675522	FIX: "Non-yielding Scheduler" error might occur when you
10.50.2806	2659694	http://support.microsoft.com/kb/2659694/	CU #5 for SQL Server 2008 R2 SP1
10.50.2799	2633357	http://support.microsoft.com/kb/2633357	FIX: "Non-yielding Scheduler" error might occur when you
10.50.2796	2633146	http://support.microsoft.com/kb/2633146	CU#4 for SQL Server 2008 R2 SP1
10.50.2789	2591748	http://support.microsoft.com/kb/2591748/en-us	CU#3 for SQL Server 2008 R2 SP1
10.50.2776	2606883	http://support.microsoft.com/kb/2606883	FIX: Slow performance when an AFTER trigger runs on a
10.50.2772	2567714	http://support.microsoft.com/kb/2567714	CU#2 for SQL Server 2008 R2 SP1
10.50.2769	2544793	http://support.microsoft.com/kb/2544793/en-us	CU#1 for SQL Server 2008 R2 SP1
10.50.2550	MS12-070	http://technet.microsoft.com/en-us/security/bulletin/ms12-070	MS12-070 Security Bulletin
10.50.2500	2528583	http://support.microsoft.com/kb/2528583	SP 1 for SQL Server 2008 R2
10.50.1817	2703280	http://support.microsoft.com/kb/2703280	CU#14 for RTM
10.50.1815	2703280	http://support.microsoft.com/kb/2703280	CU#13 for RTM
10.50.1810	2679366	http://support.microsoft.com/kb/2679366	CU#12 for RTM
10.50.1809	2633145	http://support.microsoft.com/kb/2633145	CU#11 for RTM
10.50.1807	2591746	http://support.microsoft.com/kb/2591746/en-us	CU#10 for RTM
10.50.1804	2567713	http://support.microsoft.com/kb/2567713	CU#9 for RTM
10.50.1797	2534352	http://support.microsoft.com/kb/2534352	CU#8 for SQL Server 2008 R2 RTM
10.50.1790	2494086	http://support.microsoft.com/kb/2494086	MS11-049: Description of the security update for SQL Server
10.50.1777	2507770	http://support.microsoft.com/kb/2507770	CU#7 for SQL Server 2008 R2 RTM
10.50.1769	2520808	http://support.microsoft.com/kb/2520808	FIX: Non-yielding scheduler error when you run a query that
10.50.1765	2489376	http://support.microsoft.com/kb/2489376/en-us	CU#6 for SQL Server 2008 R2 RTM
10.50.1753	2438347	http://support.microsoft.com/kb/2438347	CU#5 for SQL Server 2008 R2 RTM
10.50.1746	2345451	http://support.microsoft.com/kb/2345451	CU#4 for SQL Server 2008 R2 RTM
10.50.1734	2261464	http://support.microsoft.com/kb/2261464/	CU#3 for SQL Server 2008 R2 RTM
10.50.1720	2072493	http://support.microsoft.com/kb/2072493	CU#2 for SQL Server 2008 R2 RTM
10.50.1702	981355	http://support.microsoft.com/kb/981355/en-us	CU#1 for SQL Server 2008 R2 RTM
10.50.1600		N/A	RTM
10.50.1450		N/A	RC 0
10.50.1352			CTP Nov 2009
10.50.1092			CTP Jun 2009

Again, if you find something not listed, let me know.

Resources:

buildlist2008R2.xls

Total article views: 42859 | Views in the last 30 days: 1093

SQL Server 2008 R2 Build List

Major Builds

Resources:

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

SQL Server 2008 R2 Build List

Major Builds

Resources:

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: