SQL Server 2008 R2 Build Numbers and Version History

SQL Server 2008 R2 has an engine version beginning with 10.50. Its final service pack is SP3. SQL Server 2008 builds begin with 10.0 and have their own history.

SQL Server 2008 R2 RTM, SP3 and support dates

Version prefix
10.50
Original release (RTM)
10.50.1600.1
Final service pack (SP3)
10.50.6000.34

Microsoft lists as the end of extended support. Microsoft Lifecycle

Microsoft engine history checked .

Identify SQL Server 2008 R2 SP3 and 10.50 builds

The minor version identifies the release family even though both products use major version 10. Keep all four parts of the build in reports so migration tools and patch records can distinguish R2 from the original 2008 engine. Verify the target engine’s supported backup and restore path separately from the service pack.

Run SELECT SERVERPROPERTY('ProductVersion'); to get the full engine build. SQL Server version queries · SQL Server 2008 (10.0) build history

SQL Server 2008 R2 build history and KB articles

Find the exact build or KB in the table. Use the release date and update label to confirm the match. A dash means the source did not provide that field.

Windows builds

Original release
BuildUpdateFile versionKB articlesRelease date
10.50.1600.1RTM——
Cumulative update
BuildUpdateFile versionKB articlesRelease date
10.50.4319.010.50.4319.00SP2 · CU13—KB2967540
10.50.4305.010.50.4305.00SP2 · CU12—KB2938478
10.50.4302.010.50.4302.00SP2 · CU11—KB2926028
10.50.4297.010.50.4297.00SP2 · CU10—KB2908087
10.50.4295.010.50.4295.00SP2 · CU9—KB2887606
10.50.4290.010.50.4290.00SP2 · CU8—KB2871401
10.50.4286.0SP2 · CU7—KB2844090
10.50.4279.0SP2 · CU6—KB2830140
10.50.4276.010.50.4276.00SP2 · CU5—KB2797460
10.50.4270.010.50.4270.00SP2 · CU4—KB2777358
10.50.4266.010.50.4266.00SP2 · CU3—KB2754552
10.50.4263.010.50.4263.00SP2 · CU2—KB2740411
10.50.4260.010.50.4260.00SP2 · CU1—KB2720425
10.50.2881.010.50.2881.00SP1 · CU14—KB2868244
10.50.2876.010.50.2876.00SP1 · CU13—KB2855792
10.50.2874.010.50.2874.00SP1 · CU12—KB2828727
10.50.2869.010.50.2869.00SP1 · CU11—KB2812683
10.50.2868.010.50.2868.00SP1 · CU10—KB2783135
10.50.2866.010.50.2866.00SP1 · CU9—KB2756574
10.50.2822.010.50.2822.00SP1 · CU8—KB2723743
10.50.2817.010.50.2817.00SP1 · CU7—KB2703282
10.50.2811.010.50.2811.00SP1 · CU6—KB2679367
10.50.2806.010.50.2806.00SP1 · CU5—KB2659694
10.50.2796.010.50.2796.00SP1 · CU4—KB2633146
10.50.2789.010.50.2789.00SP1 · CU3—KB2591748
10.50.2772.010.50.2772.00SP1 · CU2—KB2567714
10.50.2769.010.50.2769.00SP1 · CU1—KB2544793
10.50.1815.010.50.1815.00CU13—KB2679366
10.50.1810.010.50.1810.00CU12—KB2659692
10.50.1809.010.50.1809.00CU11—KB2633145
10.50.1807.010.50.1807.00CU10—KB2591746
10.50.1804.010.50.1804.00CU9—KB2567713
10.50.1797.010.50.1797.00CU8—KB2534352
10.50.1777.010.50.1777.00CU7—KB2507770
10.50.1765.010.50.1765.00CU6—KB2489376
10.50.1753.010.50.1753.00CU5—KB2438347
10.50.1746.010.50.1746.00CU4—KB2345451
10.50.1734.010.50.1734.00CU3—KB2261464
10.50.1720.010.50.1720.00CU2—KB2072493
10.50.1702.010.50.1702.00CU1—KB981355
GDR
BuildUpdateFile versionKB articlesRelease date
10.50.6785.2SP3 · GDR Security Update—KB5021112
10.50.6560.0SP3 · ADV180002: GDR Security Update—KB4057113
10.50.6220.0SP3 · MS15-058: GDR Security Update—KB3045316
10.50.4042.010.50.4042.00SP2 · MS15-058: GDR Security Update—KB3045313
10.50.4033.010.50.4033.00SP2 · MS14-044: GDR Security Update—KB2977320
10.50.2550.010.50.2550.00MS12-070: GDR Security Update—KB2754849
10.50.1617.010.50.1617.00MS11-049: GDR Security Update—KB2494088
Hotfix
BuildUpdateFile versionKB articlesRelease date
10.50.6529.0SP3 · MS15-058: QFE Security Update—KB3045314
10.50.4339.010.50.4339.00SP2 · MS15-058: QFE Security Update—KB3045312
10.50.4321.010.50.4321.00SP2 · MS14-044: QFE Security Update—KB2977319
10.50.2861.010.50.2861.00SP1 · MS12-070: QFE Security Update—KB2716439
10.50.2799.0Hotfix2009.100.2799.0KB2633357 (archive)—
10.50.1790.010.50.1790.00MS11-049: QFE Security Update—KB2494086
Other build
BuildUpdateFile versionKB articlesRelease date
10.50.6000.34SP3 · Service Pack—KB2979597
10.50.4000.0SP2 · Service Pack—KB2630458
10.50.2500.0SP1 · Service Pack—KB2528583

Download release CSVBuild data and APIPlan a SQL Server patchFind SQL Server security updates

SQL Server 2008 R2 release sources