THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Downloads   Opml View as RSS news feed in XML

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

New Cumulative Updates for SQL Server 2008 RTM & SP1

Late last night, the SQL Server Release Services team announced new cumulative updates for both SQL Server 2008 RTM and SQL Server 2008 SP1.

There are too many fixes to mention, but I once again notice the trend that the "newer" branch (SP1) has more fixes than the RTM branch.  I suppose they are serious about their commitment to end support for SQL Server 2008 RTM on April 13th of this year.  If you haven't already planned upgrading your instances to SP1, it is definitely time to start thinking about it.

Cumulative Update 6 for SQL Server 2008 SP1 (KB #977443) brings you to build 10.00.2757.

Cumulative Update 9 for SQL Server 2008 RTM (KB #977444) brings you to build  10.00.1828.

As a note, these CUs once again contain a wide variety of files.  The point of these files is to allow you to download and apply only the SNAC or Report Builder updates, which are smaller files.  If you are not sure that you only need an individual update, then your best bet is to always download the file "SQL_Server_2008_<SP1>_Cumulative_Update_<#>" for your platform - the installer will figure out which components are eligible for the update.  I wonder when the process that creates the files is going to be corrected so it spells "cumulative" correctly?

You can see the official announcements here and here.

Published Tuesday, January 19, 2010 10:23 AM by AaronBertrand

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

The Morning Brew - Chris Alcock » The Morning Brew #521 said:

PingBack from http://blog.cwa.me.uk/2010/01/20/the-morning-brew-521/

January 20, 2010 5:54 AM
 

Itzik Ben-Gan said:

Hi Aaron,

It seems that the download for the update for SP1 actually contains the update for RTM. Hope this will be fixed soon. Did anyone manage to obtain and install the right one?

January 20, 2010 7:14 AM
 

AaronBertrand said:

Hi Itzik, are you saying that the download page for SP1 shows the RTM files, or that when you request the SP1 files, you are offered the RTM files, or that after you download the SP1 files, it turns out that you actually received the RTM files?  I am trying now...

January 20, 2010 9:44 AM
 

Itzik Ben-Gan said:

I go to the SP1 page (http://support.microsoft.com/kb/977443).

I mark the hotfix: SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_6.

I get an e-mail with the download link and download a file called 404435_intl_x64_zip, so according to the name (contains 443) I can assume it is supposed to be for SP1.

I execute the file, extracting it, but the extracted file is called SQLServer2008-KB977444-x64, so from the name (contains 444) I suspect they packaged the wrong one.

January 20, 2010 10:34 AM
 

AaronBertrand said:

Thanks Itzik, you are totally right.  All signs indicate CU6 for SP1 but it is actually CU9 for RTM.  I've left a comment here:

http://blogs.msdn.com/sqlreleaseservices/archive/2010/01/18/cumulative-update-6-for-sql-server-2008-service-pack-1.aspx#comments

January 20, 2010 11:16 AM
 

Glenn Berry said:

I saw that same behavior on a test system yesterday afternoon, but I thought maybe I had downloaded the wrong package at first.

I have pinged a few people in the Product Group about it, so we'll see how long it takes to fix it.

January 20, 2010 12:19 PM
 

AaronBertrand said:

Thanks Glenn.  I posted a separate entry about the failures in the CU process in general:

http://sqlblog.com/blogs/aaron_bertrand/archive/2010/01/20/mis-steps-in-the-publication-of-cumulative-updates.aspx

January 20, 2010 1:19 PM
 

AaronBertrand said:

As IL pointed out on my more recent entry about CUs, the packages have been corrected, updated and re-published:

http://blogs.msdn.com/sqlreleaseservices/archive/2010/01/20/new-sql-server-2008-sp1-cu-6-packages-available.aspx

January 21, 2010 9:51 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication
©2006-2010 SQLblog.comTM
Brought to you by Adam Machanic & Peter DeBetta
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement