What DBA should do after SQL Server 2008 R2 SP1 and CU1 patch release?

Leave a comment (0) Go to comments

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.


EOF - What DBA should do after SQL Server 2008 R2 SP1 and CU1 patch release?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.