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
Filed under: Microsoft, SQL Server 2008 R2 Tagged: Service Pack 2