SQL Server 2008 R2 SP1 CU1 is now available!

SQL Server / SQL Server 2008 R2

SQL Server 2008 R2 SP1 CU1 is now available!

Aaron Bertrand July 18th, 2011 SQL Server / SQL Server 2008 R2 3

For those of you that held out on installing SQL Server 2008 R2 Service Pack 1 because it was missing the fixes from RTM's Cumulative Updates 7 & 8, your wait is over – CU1 is here and it contains these fixes. I didn't verify this for every fix individually, but this is supposed to be the goal, so I'm going to take a leap of faith here. You can download the CU here (and you can read about the rest of SP1 in a previous blog post):

KB #2544793 : Cumulative update package 1 for SQL Server 2008 R2 Service Pack 1

The build number is 10.50.2769.

Slipstreaming

Here is Peter Saddow's advice on slipstreaming Service Pack 1 into the RTM binaries:

http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx

And you can follow his steps for combining SP1 + CU1 for SQL Server 2008 – the process is largely the same:

http://blogs.msdn.com/b/petersad/archive/2009/04/16/create-a-merged-slipstream-drop-containing-sql-server-2008-server-pack-1-and-a-cumulative-update-cu-based-on-server-pack-1.aspx

A Reminder

And once again, just to be clear, this Cumulative Update is for SQL Server 2008 R2 SP1, not for SQL Server 2008 R2 RTM (build # < 10.50.2425) and not for SQL Server 2008 (build number 10.00.anything). Note that Microsoft did also release cumulative updates for SQL Server 2008 SP1 & SP2 today.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

Francisco says:

July 22, 2011 at 4:23 PM

Thanks a lot, Aaron. I'll do it.
AaronBertrand says:

July 22, 2011 at 3:54 PM

The security patch is included in Service Pack 1 (see the update toward the bottom of this post: /blogs/aaron_bertrand/archive/2011/07/12/sql-server-2008-r2-service-pack-1-is-now-available.aspx). So, install SP1 and CU1 and you will be up to date.
Francisco says:

July 22, 2011 at 10:16 AM

Hi Aaron.
Congratulations for your web site, wich is very useful for those of us who are in charge of the SQL Server administration.
I'm thinkink of installing SP1 and CU1, but I'm not sure if I should install before the KB2494088 security patch.
I've read the information on CU1 and SP1 related to hotfixes they include, but I'm not found anything about KB2494088. So I must suppose that KB2494088 is not included.
I left also a question in Microsoft SQL Server Release Services page, bur for the moment I haven't had any answer.
So, should I install before the KB2494088 security patch? That patch seems to cause some failure on SQL Server 2008 R2 RTM, with is mine.