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.
NOTE: SQL Server 2008 R2 fell out of mainstream support on July 8, 2014. It was removed from extended support on July 9, 2019.
You can download a csv of builds here.
Major Builds
| Build | KB Article | Title | Description |
| 10.50.6000 | 2979597 | Service Pack 3 for SQL Server 2008 R2 | Final Service Pack for SQL Server 2008 R2 |
| 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.6560 | 4057113 | https://support.microsoft.com/en-us/help/4057113/security-update-for-vulnerabilities-in-sql-server | Meltdown/Spectre CPU patch from ADV180002 | |
| 10.50.6529 | 3045314 | http://support.microsoft.com/kb/3045314 | MS15-058 QFE | |
| 10.50.6220 | 3045316 | http://support.microsoft.com/kb/3045316 | MS15-058 GDR | |
| 10.50.6000 | 2979597 | Service Pack 3 for SQL Server 2008 R2 | ||
| 10.50.4339 | 3045312 | http://support.microsoft.com/kb/3045312 | MS15-058 Security Patch - QFE | |
| 10.50.4321 | 2977319 | MS14-044 | QFE Patch | |
| 10.50.4319 | 2967540 | http://support.microsoft.com/kb/2967540 | CU #13 for SQL Server 2008 R2 SP2 | |
| 10.50.4305 | 2938478 | http://support.microsoft.com/kb/2938478/en-us | CU #12 for SQL Server 2008 R2 SP2 | |
| 10.50.4302 | 2926028 | http://support.microsoft.com/kb/2926028 | CU #11 for SQL Server 2008 R2 SP2 | |
| 10.50.4297 | 2908087 | http://support.microsoft.com/kb/2908087 | CU #10 for SQL Server 2008 R2 SP2 | |
| 10.50.4295 | 2887606 | http://support.microsoft.com/kb/2887606 | CU #9 for SQL Server 2008 R2 SP2 | |
| 10.50.4290 | 2871401 | http://support2.microsoft.com/kb/2871401 | CU #8 for SQL Server 2008 R2 SP2 | |
| 10.50.4286 | 2844090 | http://support.microsoft.com/kb/2844090 | CU #7 for SQL Server 2008 R2 SP2 | |
| 10.50.4285 | 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.4042 | 3045313 | http://support.microsoft.com/kb/3045313 | MS15-058 GDR | |
| 10.50.4033 | 2977320 | https://technet.microsoft.com/en-us/library/security/MS14-044 | MS14-044 GDR | |
| 10.50.4000 | 2630458 | support.microsoft.com/kb/2630458 | Service Pack 2 | |
| 10.50.2881 | 2868244 | http://support.microsoft.com/kb/2868244 | CU#14 for SQL Server 2008 R2 SP1 | |
| 10.50.2876 | 2855792 | http://support.microsoft.com/kb/2855792 | CU#13 for SQL Server 2008 R2 SP1 | |
| 10.50.2875 | 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.
Microsoft KB Articles with rollups of releases
