http://www.sqlservercentral.com/blogs/glennberry/2012/07/28/sql-server-2008-r2-service-pack-2/

Printed 2014/07/26 09:48AM

SQL Server 2008 R2 Service Pack 2

2012/07/28

Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through SQL Server 2008 Service Pack 1 CU5. If you have already installed SQL Server 2008 R2 SP1 CU6 or CU7, you will want to wait until Microsoft releases SQL Server 2008 R2 SP2 CU1 (which should be relatively soon if past history is any guide). The release notes are here. This Service Pack is only for SQL Server 2008 R2.

This build chart should make the relationship between the SP1 and SP2 branches more clear. Although I don’t have a link, Microsoft will typically retire the RTM branch when Service Pack 2 has been released. That means that if you are still on the RTM branch, you are going to want to get on a newer branch (preferably SP2) as soon as you can.

     SQL Server 2008 R2 SP1 Builds     SQL Server 2008 R2 SP2 Builds
     Build             Description                          Build              Description
– 10.50.2500  SP1 RTM
– 10.50.2769  SP1 CU1
– 10.50.2772  SP1 CU2
– 10.50.2789  SP1 CU3
– 10.50.2796  SP1 CU4
– 10.50.2806  SP1 CU5        —>              10.50.4000    SP2 RTM
– 10.50.2811  SP1 CU6
– 10.50.2817  SP1 CU7      

The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released


Filed under: Microsoft, SQL Server 2008 R2 Tagged: Service Pack 2
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.