Search results matching tags 'patches', 'SQL Server 2008 SP1', and 'hotfixes'

SQL Server 2008 SP1 CU #9 is available

AaronBertrand — Mon, 26 Jul 2010 13:36:00 GMT

The SQL Server Release Services team recently announced that they have released a new Cumulative Update for SQL Server 2008 SP1:

http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/07/19/cumulative-update-9-for-sql-server-2008-service-pack-1.aspx

This update will bring you to build 10.00.2789. From the looks of the KB article, a healthy dose of fixes are made available in this update (a lot more than it looks like are in store for SP2).

KB #2083921 : Cumulative update package 9 for SQL Server 2008 Service Pack 1

Note that if you have installed the SQL Server 2008 SP2 CTP (which I talked about previously), you should not attempt to install this update. It is likely that shortly after the final release of SP2 is made available, there will be a follow-up Cumulative Update that will be published, and will include all or most of the fixes from CU #9.

Edit for Roger Falor: yes, the 64-bit version is available. When you go to the KB article and select "View and request Hotfix Downloads," the KB article tries to do you a favor, and presents you only downloads for the platform you're currently running. So in your case, you've probably gone looking for the 64-bit hotfix but you're using an x86 machine. Here is what you'll see:

If you click on "Show hotfixes for all platforms and languages," you will get more options. I've highlighted the one you're after in the following screen shot:

SQL Server 2008 SP2 (CTP) is available for testing

AaronBertrand — Thu, 08 Jul 2010 15:23:00 GMT

While I don't recommend you rush out and deploy this to your production instances today, it might not be a bad idea to get a head start on testing the fixes in SQL Server 2008 SP2 in your development and/or test environments. I have tested it on a few standalone machines, and so far have not come across any issues. I have not yet attempted to install it on any clusters.

You can download the CTP here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=65606fdd-093f-4c70-91f6-dc1f24520e8f

If you want the Express Editions, go here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c56e753d-13ef-4b95-a5eb-0b470bf56341

You can read about what's fixed in KB #979450:

http://support.microsoft.com/?kbid=979450

This will put you at build 10.0.3798.0. While the list of fixes for the SP2 CTP itself is small, you should also consider what build you're at now. Most of the fixes from cumulative updates released after SP1 will also be included (and I think this is part of the reason the CU releases got out of sync last month; potentially they are trying to avoid the "SP removes fixes from the most recent CU" problem that we've seen in the past). Here is the list:

SQL Server 2008 SP1 Cumulative Update #8 (10.0.2775): http://support.microsoft.com/?kbid=981702
SQL Server 2008 SP1 Cumulative Update #7 (10.0.2766): http://support.microsoft.com/?kbid=979065
SQL Server 2008 SP1 Cumulative Update #6 (10.0.2757): http://support.microsoft.com/?kbid=977443
SQL Server 2008 SP1 Cumulative Update #5 (10.0.2746): http://support.microsoft.com/?kbid=975977
SQL Server 2008 SP1 Cumulative Update #4 (10.0.2734): http://support.microsoft.com/?kbid=973602
SQL Server 2008 SP1 Cumulative Update #3 (10.0.2723): http://support.microsoft.com/?kbid=971491
SQL Server 2008 SP1 Cumulative Update #2 (10.0.2714): http://support.microsoft.com/?kbid=970315
SQL Server 2008 SP1 Cumulative Update #1 (10.0.2710): http://support.microsoft.com/?kbid=969099

And if you're not even on SP1 yet, I'd love to know what you're waiting for...

You should also note that SP2 brings support for Data-Tier Applications, the SQL Server Utility, and a SharePoint add-in.

New Cumulative Updates for SQL Server 2008 SP1 & R2!

AaronBertrand — Wed, 19 May 2010 00:01:00 GMT

Well, this is the first time in a long time that I've blogged about cumulative updates for two different versions of SQL Server on the same day. Yesterday Microsoft released a cumulative update for SQL Server 2008 SP1 (bringing you to 10.0.2775), and a corresponding cumulative update for SQL Server 2008 R2 RTM (bringing you from 10.50.1600 to 10.50.1702). You can read more about these updates here:

Cumulative Update #1 for SQL Server 2008 R2 RTM
(KB #981355)
Cumulative Update #8 for SQL Server 2008 Service Pack 1
(KB #981702)

Note that the cumulative update for SQL Server 2008 R2 is merely a rollup of the updates found in cumulative updates 5, 6 and 7 for 2008 SP1 - it does not include several of the fixes from CU #8 for 2008 SP1. I would expect to see a continued pattern of bugs relevant to both versions being fixed in one branch, and not rolled into the other until the subsequent update (and where it appears first will depend on where it was discovered).

Mis-steps in the publication of Cumulative Updates

AaronBertrand — Wed, 20 Jan 2010 17:31:00 GMT

It used to be very difficult to obtain hotfixes for SQL Server (sometimes even to learn about their existence), and they were often unsupported. They have made extremely great strides in this area, and in general, I find the new procedure much more convenient : just go to the KB article, select the fix(es) you want, and you get an almost immediate e-mail with download links and brief instructions. No longer do I have to raise an issue with customer support and prove to them that I am both affected by the issue and responsible enough to handle the patch correctly. But there are still some holes in the process.

1. Trying to be "smart" about platform

The hotfix download page determines your platform and language and offers you the patch files for your current local environment. While this might be a good idea in some cases (such as client patches), for SQL Server this makes no sense at all. This methodology assumes that I am downloading patches only for my immediate machine, when in reality I am usually downloading for a variety of instances, many of which are not even on the same subnet as my workstation. Add to this the fact that in my experience the code just doesn't work - this is a pure x64 machine, and yet because I am using Firefox, the download page for every cumulative update thus far has limited my view to the x86 files. It is only a minor piece of extra work to get access to the x64 files I'm really after (simply click on the "Show hotfixes for all platforms and languages" link), but ideally I'd like to see a setting where (via a cookie, or LiveID, or something) I could say "always show all platforms" or "always show both x64 and x86 files." Or take away the "smarts" that hide the other platforms from me in the first place - presumably this is just a way to avoid actually documenting the files in sections, so silly people don't download files for the wrong platform.

2. Publication of correct files and filenames

While the screen shot will only highlight the repeating spelling error ("cumlative" vs. "cumulative") that has afflicted the last few cumulative updates, there was a pretty serious mistake in this most recent CU where the SP1 download actually contained the patch for RTM. Now a lot of people are extracting the file, trying to run it against their SP1 instances, and it finds there is nothing to update. Rather than assume a simple case of mistaken identity, many will assume that either the patch or their environment is broken. Right now you'll notice in the screenshot below that the core file has been pulled from the download page, so they are fixing the problem - in fact it has probably been corrected by the time you are reading this. But why was it wrong in the first place? Are the download packages not tested even once before they are published?

3. Being vague about the included files

There are always several files in each CU download, and they are not explained anywhere either on the download page or the original KB page. What is a "SapBi" or "RB2ClickOn" file? Do I need it? Who knows? I really believe that for each CU they need to have some section on the download page describing the use case where you would want to download any of the smaller files individually.

The proof

The proof is, as they say, in the pudding. You can see the highlighted areas in the screenshot from the points above (click to embiggen):

What to do?

Without direct interaction with those involved, I am not sure what else we can do to make corrections to these processes. The feeling of a CU is already inherently "rushed"; then when the files are published clearly without testing or attention to detail, that rushed feeling is exaggerated. I have commented about this problem on Connect and in a previous bog post. I've also stressed the need to fully document CUs before releasing them (but somehow left out the "testing" part). After today's incident, it is obvious there are still some items that have room for improvement.

At least from the outside, they look like relatively simple things to fix. Fixing them would lead to a lot less confusion among the customer base, and a lot more confidence in the general approach and attitude toward releasing updates. A lot of that is just about better communication. For example, while they were fixing this problem, they did not make any announcements whatsoever; they simply pulled the core files from the download page.

New Cumulative Updates for SQL Server 2008 RTM & SP1

AaronBertrand — Tue, 19 Jan 2010 14:23:00 GMT

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.