SQL Server 2008 R2

The below table reflects the builds released for SQL Server 2008 R2 as well as key comments that relate to the build where appropriate.

 

Please note that SQL Server 2008 R2 patches are different from SQL Server 2008 patches and therefore only use the patches listed here for SQL Server 2008 R2 installations.

 

The current recommended Build is 10.50.6529.0 (SP3 with MS15-058).
 

Patch Build Type* Released Comment
MS15-058 10.50.6529.0 QFE 2015 Jul Use if SP3 QFE build is 10.50.6525.0.
MS15-058 10.50.6220.0 GDR 2015 Jul Use if SP3 GDR build is 10.50.6000.34.
MS15-058 10.50.4339.0 QFE 2015 Jul Use with SP2 QFE builds between and including 10.50.4260.0 to 10.50.4321.0
MS15-058 10.50.4042.0 GDR 2015 Jul Use with SP2 GDR builds between and including 10.50.4000.0 to 10.50.4033.0.
SP3_hotfix 10.50.6525.0 QFE 2015 Feb Contains 2 fixes.
SP3 10.50.6000.34 SP 2014 Sep Last Service Pack for SQL Server 2008 R2.

There is an issue with this Service Pack in regards to Report Builder if you have already applied SP2.

Includes SP2 CU13 and MS14-044.

Can also be applied to SQL Server 2008 R2 Express Edition.
MS14-044 10.50.4321.0 QFE 2014 Aug Use with SP2 QFE path.
MS14-044 10.50.4033.0 GDR 2014 Aug Use with SP2 GDR path.
SP2_CU13 10.50.4319.0 QFE 2014 Jun

SP2_CU13

10.50.4319.0

QFE

2014 Jun

Final CU for SP2.
Mainstream support for SQL Server 2008 R2 ends on 8 July 2014.
Introduces DATABASE lock partitioning when trace flag T1236 is enabled at startup.
LOB disk space reclaim fix.

SP2_CU12

10.50.4305.0

QFE

2014 Apr

SP2_CU11

10.50.4302.0

QFE

2014 Feb

SP2_CU10

10.50.4297.0

QFE

2013 Dec

SP2_CU9

10.50.4295.0

QFE

2013 Oct

SP2_CU8

10.50.4290.0

QFE

2013 Aug

SP1_CU14

10.50.2881.0

QFE

2013 Aug

SP2_CU7

10.50.4286.0

QFE

2013 Jun

SP1_CU13

10.50.2876.0

QFE

2013 Jun

SP2_CU6

10.50.4285.0

QFE

2013 Jun

There was an issue with original April CU (build number 10.50.4279.0) and it was re-released as build number 10.50.4285.02 new features:

Backup and restore from SQL Server to Windows Azure Blob storage

Sysprep to include Analysis Services, Integration Services & most shared features

SP1_CU12

10.50.2875.0

QFE

2013 Jun

There was an issue with original April CU (build number 10.50.2874.0) and it was re-released as build number 10.50.2875.0

SP2_CU5

10.50.4276.0

QFE

2013 Feb

Contains 21 fixes.Adds ability to exclude system databases from a Query Statistics collection set in Management Data Warehouse.

SP1_CU11

10.50.2869.0

QFE

2013 Feb

Contains 4 fixes.

SP2_CU4

10.50.4270.0

QFE

2012 Dec

Contains 34 fixes.Adds support for the varchar(max), nvarchar(max), and varbinary(max) data types in most OLE DB providers.

Resolves a memory leak if the Auto Update Statistics Asynchronously option is enabled.

SP1_CU10

10.50.2868.0

QFE

2012 Dec

Adds support for the varchar(max), nvarchar(max), and varbinary(max) data types in most OLE DB providers.Resolves a memory leak if the Auto Update Statistics Asynchronously option is enabled.

SP2_CU3

10.50.4266.0

QFE

2012 Oct

SP1_CU9

10.50.2866.0

QFE

2012 Oct

MS12-070

10.50.2861.0

QFE

2012 Oct

For use with SP1 if you are on the QFE path of patching.SP2 is not affected.

MS12-070

10.50.2550.0

GDR

2012 Oct

For use with SP1 if you are on the GDR path of patching.SP2 is not affected.

SP2_CU2

10.50.4263.0

QFE

2012 Aug

Contains 9 fixes.

SP1_CU8

10.50.2822.0

QFE

2012 Aug

Contains 20 fixes.

MS12-060

NA

GDR

2012 Aug

Replaces MS12-027.Critical patch which updates the MSCOMCTL.OCX file to version 6.01.9834.

SP2_CU1

10.50.4260.0

QFE

2012 Jul

Includes SP1_CU6/7.Contains 35 fixes.

SP2

10.50.4000.0

SP

2012 Jul

Includes SP1_CU1/2/3/4/5.

Trace flag 1264 has been removed.

SP1_CU7

10.50.2817.0

QFE

2012 Jun

Fix for Reporting Services KeepFilesForDays.

RTM_CU14

10.50.1817.0

QFE

2012 Jun

Fix for error: 18056, Severity: 20, State: 29. Fix for Reporting Services KeepFilesForDays.

SP1_CU6

10.50.2811.0

QFE

2012 Apr

RTM_CU13

10.50.1815.0

QFE

2012 Apr

MS12-027

NA

GDR

2012 Apr

Critical patch which updates the MSCOMCTL.OCX file to version 6.01.9833.

SP1_CU5

10.50.2806.0

QFE

2012 Jan

RTM_CU12

10.50.1810.0

QFE

2012 Jan

SP1_CU4

10.50.2796.0

QFE

2011 Dec

Trace flags 2562 and 2549 introduced for DBCC CHECKDB.

RTM_CU11

10.50.1809.0

QFE

2011 Dec

Trace flags 2562 and 2549 introduced for DBCC CHECKDB.

SP1_CU3

10.50.2789.0

QFE

2011 Oct

RTM_CU10

10.50.1807.0

QFE

2011 Oct

SP1_CU2

10.50.2772.0

QFE

2011 Aug

RTM_CU9

10.50.1804.0

QFE

2011 Aug

SP1_CU1

10.50.2769.0

QFE

2011 July

SP1

10.50.2500.0

SP

2011 July

Includes RTM_CU1/2/3/4/5/6.

Support for 512e Drives.

EOL** (SP 2013 Oct )

RTM_CU8

10.50.1797.0

QFE

2011 Jun

MS11_049

10.50.1790.0

QFE

2011 Jun

Includes RTM_CU1/2/3/4/5/6/7.

MS11_049

10.50.1617.0

GDR

2011 Jun

Has known issues.

RTM_CU7

10.50.1777.0

QFE

2011 Apr

CU has known issues with Visual Studio 2010.

RTM_CU6

10.50.1765.0

QFE

2011 Feb

RTM_CU5

10.50.1753.0

QFE

2010 Dec

RTM_CU4

10.50.1746.0

QFE

2010 Oct

RTM_CU3

10.50.1734.0

QFE

2010 Aug

RTM_CU2

10.50.1720.0

QFE

2010 Jun

RTM_CU1

10.50.1702.0

QFE

2010 May

Trace Flag 4135 was included in Trace Flag 4199.

RTM

10.50.1600.1

2010 Apr

EOL** (MS 2014 Jan, ES 2019 Jan, SP 2012 July)

* Build Types can be either:

SP – Service Pack (This patch is recommended to be applied if it is supported by your application and testing in a non-Production environment is successful.)

GDR – General Distribution Release (Same recommendation as a Service Pack.)

QFE – Quick Fix Engineering (This type of patch should only be applied if it contains a fix to an issue being experienced.)

** EOL – End of Life for Product

SP (Service Pack Support End Date)

MS (Mainstream Support End Date)

ES (Extended Support End Date)