Friday, March 30, 2007
How to Make Sense of SQL Server 2005 Hotfix Builds 9.0.3050 and 9.0.3152
In case you don't know, for a few weeks, we have build 9.0.3042 of SQL Server 2005 SP2 but, on March 6, 2007, it was "refreshed" to 9.0.3043 so that it included a hotfix for some pretty intense maintenance plan scheduling failures.
Now, the same day they released 9.0.3043, MSFT also released build 9.0.3050 which is for those people who installed the original version of SP2 (9.0.3042). Yes, this is a bit strange: build 3050 effectively brings SQL Server 2005 SP2 build 9.0.3050 "down to" SQL Server 2005 SP2 build 3043's level. KB Article is dated March 23.... At least, given the docs, that's what I *think* is the case.
The very next day came build 9.0.3152 (March 7, 2007) which is billed as a "Cumulative Hotfix for SP2". This includes the file sqlserver2005-kb933097-x86-enu.exe and it resolves a bunch of bugs but apparently it wasn't ready to be released on March 6 so it was released on March 7.
Are you still reading?
Good. I need you here because actually, I'm kind of lost as to what to install! Does build 3152 include the fixes in 3050 or is it only for 3043? The KB article says that it is a cumulative hotfix but does not mention builds 4050, 3043 or 3042 at all. The KB article for 3152 mentions builds
2214 and 2219 only.....................
Do I need to uninstall 3050 just to install 3152?
Does 3152 require 3043 only?
Arrrgghhhhh!
Sooooooooo - I've just installed 3152... Let me go check it out and see what it says (and whether the SQL Server 2005 Performance Dashboard reports run successfully since they didn't on build 3050).
..........................
Well, the ProductLevel is still SP2 (SELECT SERVERPROPERTY('ProductLevel') ) but now the ProductVersion shows 9.0.3152 (SELECT SERVERPROPERTY('ProductVersion')) but the SQL Server Performance Dashboard reports still don't work... So much for that!
Now, the same day they released 9.0.3043, MSFT also released build 9.0.3050 which is for those people who installed the original version of SP2 (9.0.3042). Yes, this is a bit strange: build 3050 effectively brings SQL Server 2005 SP2 build 9.0.3050 "down to" SQL Server 2005 SP2 build 3043's level. KB Article is dated March 23.... At least, given the docs, that's what I *think* is the case.
The very next day came build 9.0.3152 (March 7, 2007) which is billed as a "Cumulative Hotfix for SP2". This includes the file sqlserver2005-kb933097-x86-enu.exe and it resolves a bunch of bugs but apparently it wasn't ready to be released on March 6 so it was released on March 7.
Are you still reading?
Good. I need you here because actually, I'm kind of lost as to what to install! Does build 3152 include the fixes in 3050 or is it only for 3043? The KB article says that it is a cumulative hotfix but does not mention builds 4050, 3043 or 3042 at all. The KB article for 3152 mentions builds
2214 and 2219 only.....................
Do I need to uninstall 3050 just to install 3152?
Does 3152 require 3043 only?
Arrrgghhhhh!
Sooooooooo - I've just installed 3152... Let me go check it out and see what it says (and whether the SQL Server 2005 Performance Dashboard reports run successfully since they didn't on build 3050).
..........................
Well, the ProductLevel is still SP2 (SELECT SERVERPROPERTY('ProductLevel') ) but now the ProductVersion shows 9.0.3152 (SELECT SERVERPROPERTY('ProductVersion')) but the SQL Server Performance Dashboard reports still don't work... So much for that!
Labels: sql 2005, sql server 2005, sql server 2005 sp2
Comments:
Links to this post:
<< Home
Here's the lastest (and maybe the last) advice for updating SQL Server 2005 SP2 to fix the management plan problems:
For builds between 3042 and 3053, go to KB934458 to get and install build 3054.
For any build between 3150 and 3158, go to KB934459 to get and install build 3159.
Build 3054 is the right one for most people. But there are a few QFEs (quick fixes) already released with builds in the 3150s. Folks with those QFEs need to keep them, but they also need the lastest patch. So MSFT put out build 3159, which has these quick fixes and the new patch as well.
This MSDN forum thread explains it a little more fully:
Steve Kass
SQL Server MVP
Drew University
http://www.stevekass.com
Post a Comment
For builds between 3042 and 3053, go to KB934458 to get and install build 3054.
For any build between 3150 and 3158, go to KB934459 to get and install build 3159.
Build 3054 is the right one for most people. But there are a few QFEs (quick fixes) already released with builds in the 3150s. Folks with those QFEs need to keep them, but they also need the lastest patch. So MSFT put out build 3159, which has these quick fixes and the new patch as well.
This MSDN forum thread explains it a little more fully:
Steve Kass
SQL Server MVP
Drew University
http://www.stevekass.com
Links to this post:
<< Home
