Microsoft has recently released some patches and Service Packs for SQL Server. Lets see what are these.
Microsoft SQL Server 2008 R2 Service Pack 1 – This service pack contains the cumulative updates of SQL Server 2008 R2 cumulative update packages 1 to 6. Once you installed SQL Server R2 Service pack 1, your version will become 10.50.2500.0
SQL Server 2008 R2 Service Pack 1 consolidates more than 150 quick fixes and improvements. This was released on July/11/2011
Cumulative update package 1 (CU1) for Microsoft SQL Server 2008 R2 Service Pack 1 – with in a weeks time (July 18, 2011), Microsoft releases CU1 for SQL Server 2008 R2 SP1, which make SQL Server Version 10.50.2769.0. to fix issues, which are being reported by community.
So what we should should do now, after these confusing releases ?
If you are running your SQL Server 2008 R2 with CU6 (Build 10.50.1765.0 ) or lower build, then the official Microsoft recommendation is to install the SP1 only, don’t apply CU#1 for SQL Server 2008 R2 SP1
If you have a production version of SQL Server 2008 R2 CU7 (10.50.1777.0) or CU8 (10.00.1823), then update that to SQL Server 2008 R2 Service Pack 1 and immediately after SP 1 apply CU1 for SP1. So your final SQL Server version should be 10.50.2769.0.