Search results matching tags 'hotfixes', 'SQL Server 2008 SP1', and 'sql server 2008 SP2'

Cumulative Updates for SQL Server 2005 and 2008 are available

AaronBertrand — Tue, 22 Mar 2011 12:38:00 GMT

Very early this morning, Microsoft released four updates: one for SQL Server 2005 SP3, one for SQL Server 2005 SP4, one for SQL Server 2008 SP1, and one for SQL Server 2008 SP2.

Cumulative Update
KB Article Build Number Number of Fixes

SQL Server 2005 SP3 Cumulative Update #15
KB #2507766
9.00.4325 6

SQL Server 2005 SP4 Cumulative Update #3
KB #2507769
9.00.5266 5

SQL Server 2008 SP1 Cumulative Update #13
KB #2497673
10.00.2816 12

SQL Server 2008 SP2 Cumulative Update #3
KB #2498535
10.00.4279 25

Cumulative Update	KB Article	Build Number	Number of Fixes
SQL Server 2005 SP3 Cumulative Update #15	KB #2507766	9.00.4325	6
SQL Server 2005 SP4 Cumulative Update #3	KB #2507769	9.00.5266	5
SQL Server 2008 SP1 Cumulative Update #13	KB #2497673	10.00.2816	12
SQL Server 2008 SP2 Cumulative Update #3	KB #2498535	10.00.4279	25

Note that Microsoft has officially confirmed that these are the last cumulative updates for SQL Server 2005 (both SP3 and SP4). So if you're still on SQL Server 2005, it really is time to start considering how long you want to stay on that platform.

Also, please do not try to apply the SQL Server 2008 cumulative updates to SQL Server 2008 R2 systems. You won't get very far and you won't break anything; I'm just trying to save you some time.

Cumulative Updates for SQL Server 2008 are available

AaronBertrand — Thu, 18 Nov 2010 16:51:00 GMT

On Monday, the SQL Server Release Services team released cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. The cumulative update for SP2 restores the fixes that were potentially undone by applying SP2 (or the SP2 CTP) after applying CU9 or CU10 to SP1. Confusing, yes, but at least it's straightened out now. We won't have to deal with this until the next service pack.

SQL Server 2008 SP1 Cumulative Update #11- build # 10.0.2804
KB #2413738
SQL Server 2008 SP2 Cumulative Update #1 - build # 10.0.4266
KB #2289254

And no, neither of these updates are applicable to SQL Server 2008 R2.

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.