Search results matching tags 'hotfixes' and 'SQL Server 2005 SP3'

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.

New Cumulative Updates for SQL Server 2005 & SQL Server 2008 R2

AaronBertrand — Tue, 22 Feb 2011 14:13:00 GMT

Early this morning (or late last night, depending on your time zone), the SQL Server Release Services team pushed out three new cumulative updates for SQL Server.

KB #2489375 - SQL Server 2005 SP3 CU #14 (9.00.4317)
KB #2489409 - SQL Server 2005 SP4 CU #2 (9.00.5259)
KB #2489376 - SQL Server 2008 R2 CU #6 (10.50.1765)

There are a lot more fixes in the 2008 R2 update - 43, by my count. In comparison, only 9 fixes for 2005 SP4, and only 2 fixes for 2005 SP3. You can draw your own conclusions from that data, particularly if you are still on SQL Server 2005 and are reluctant to upgrade.

And I hate to sound like a broken record, but to reiterate what I've said in other blog posts announcing CUs or service packs for 2008/2008 R2, none of the cumulative updates listed above are eligible for SQL Server 2008 (RTM, SP1 or SP2). I really hope Microsoft takes the confusion they've caused seriously.

Cumulative Updates for SQL Server 2005 SP3 and 2008 R2 are available

AaronBertrand — Tue, 21 Dec 2010 13:17:00 GMT

After releasing SQL Server 2005 SP4 on Friday (you can read more about it here), the release services team did not hang up their hats for the Christmas holiday, but continued working on other releases.

KB #2438344 : Cumulative update package 13 for SQL Server 2005 Service Pack 3
This brings your SQL Server 2005 SP3 build number to 9.00.4315
KB #2438347 : Cumulative Update package 5 for SQL Server 2008 R2
This brings your SQL Server 2008 R2 build number to 10.5.1753

NOTES:
You will not be able to apply Cumulative Update #13 to SQL Server 2005 Service Pack 4! This release is for SQL Server 2005 Service Pack 3 only. I still suspect that we won't see a cumulative update for SP4 until a month into the new year - however maybe it will contain the fixes from both CU#12 and CU#13.

You cannot apply Cumulative Update #5 to SQL Server 2008! This release is for SQL Server 2008 R2 RTM only.

SQL Server 2005 SP4 is here!

AaronBertrand — Sat, 18 Dec 2010 03:59:00 GMT

Yes, the day has finally arrived, and a couple of weeks ahead of schedule. Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day of that quarter or half. This year, we get an early Christmas present: SQL Server 2005 SP4.

Downloads

To download SP4, go to this link:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece

If you are looking for the Express versions of SP4, you can get Express, Express with Tools, and Express with Advanced Services at the following URL (though they don't really do a great job of describing which file(s) may be most appropriate for you):

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=26435597-b28e-4568-9d16-017bdf47abdc

If you want Express that can install on 32-bit or 64-bit systems, download SQLEXPR.EXE. If you know you will only install to 32-bit systems, download the smaller SQLEXPR32.EXE. (The only difference is the size of the package - I can hear the peanut gallery now. In all seriousness, there is no such thing as a 64-bit version of SQL Server Express for SQL Server 2005 - that option first arrived with SQL Server 2008.) If you want Express with Tools, use SQLEXPR_TOOLKIT.EXE, and if you want Express with Advanced Services, use SQLEXPR_ADV.EXE.

Fixes

To review the fixes in SP4, see the following Knowledge Base article:

http://support.microsoft.com/kb/2463332

I am not sure why the list is so short - SP4 does contain all of the fixes in Cumulative Updates 1 through 11 for Service Pack 3, and there are definitely more than that handful. I think this makes the service pack look a lot less useful than it actually is, especially for people who are still on SP3 or its earlier cumulative updates. Here is the full list of 11 cumulative updates, to make it a little easier to generate the full list of fixes or to find a particular fix you want to make sure is included in the service pack (see below for information about fixes in CU #12):

CU #11 (9.00.4309 - 2010-08-16) : KB #2258854
CU #10 (9.00.4305 - 2010-06-21) : KB #983329
CU #9 (9.00.4294 - 2010-04-19) : KB #980176
CU #8 (9.00.4285 - 2010-02-15) : KB #978915
CU #7 (9.00.4273 - 2009-12-21) : KB #976951
CU #6 (9.00.4266 - 2009-10-19) : KB #974648
CU #5 (9.00.4230 - 2009-08-17) : KB #972511
CU #4 (9.00.4226 - 2009-06-15) : KB #970279
CU #3 (9.00.4220 - 2009-04-20) : KB #967909
CU #2 (9.00.4211 - 2009-02-16) : KB #961930
CU #1 (9.00.4207 - 2008-12-19) : KB #959195

Most importantly (at least IMHO), this service pack finally addresses the MSXML6 issues that have plagued Windows XP SP3 users since at least February of 2009. From the fix list:

When SQL Server 2005 SP3 is applied on a machine that has a later version of MSXML6 installed, the service pack setup fails. This issue occurs when you upgrade Windows XP SP2 to Windows XP SP3 and then apply SQL Server 2005 SP3. To fix this issue, apply SQL Server 2005 SP4.

Build Number

The build number for SP4 is 9.00.5000. (This "round number" build is becoming a favorite practice not just within the SQL Server team but across a lot of other Microsoft divisions as well.) Here is the result of "SELECT @@VERSION;" on my local Express instances, just for fun (notice that even though I am running x64 there is nothing in there that tells you whether the operating system is 32-bit or 64-bit):

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) 
    Dec 10 2010 10:56:29 
    Copyright (c) 1988-2005 Microsoft Corporation
    Express Edition on Windows NT 6.1 (Build 7600: )

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) 
    Dec 10 2010 10:56:29 
    Copyright (c) 1988-2005 Microsoft Corporation
    Express Edition with Advanced Services on Windows NT 6.1 (Build 7600: )

Should you update?

You will still need to wait one Cumulative Update (CU) cycle to restore all of the fixes from SP3 CU #12. As with previous SP releases in the 2008 branches, if you've already applied CU #12 to your SQL Server 2005 SP3 instance (SELECT @@VERSION will show 9.00.4311 or greater, but less than 9.00.4912 - the build for the Service Pack 4 CTP), and you are relying on fixes in that build, you should hold off on SP4 until the first CU for SP4 is released. Usually this occurs within about a month of the service pack, but given the holidays, at this point I would expect it mid-February.

This will almost certainly be the last service pack for SQL Server 2005 - from this point forward all you're likely to see are cumulative updates to the SP3 and SP4 branches and, roughly a year from today, mainstream support will only need to maintain the SP4 branch. You can read more about this in the following blog post from the CSS blog:

Mainstream vs Extended Support and SQL Server 2005 SP4: Can someone explain all of this?

New SQL Server cumulative updates for SQL Server 2005 SP3 & 2008 R2 are here

AaronBertrand — Tue, 19 Oct 2010 02:57:00 GMT

Today Microsoft has released two updates for SQL Server. Listed below are the two updates, the blog posts from the SQL Server Release Services team, and the KB articles where you can read about the fixes and request downloads.

SQL Server 2005 SP3 Cumulative Update #12

http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/10/18/cumulative-update-12-for-sql-server-2005-service-pack-3.aspx
http://support.microsoft.com/kb/2345449

This release is build # 9.00.4311.

SQL Server 2008 R2 Cumulative Update #4

http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/10/18/cumulative-update-4-for-sql-server-2008-r2-rtm.aspx
http://support.microsoft.com/kb/2345451

This release is build # 10.50.1746.0.