Service Pack upgrade confusion

Question

Service Pack upgrade confusion

ChiragNS

One Orange Chip

Points: 26137
More actions
August 9, 2007 at 11:36 pm

#117859

Hi
I want to upgrade our SQL Server 2005 installation(RTM version)to SP2. I have been reading on this on various sites(including Microsoft) which has me a bit confused.
MS released a hotfix after SP2 so should the hotfix be installed after installing SP2. Also in some sites i found that if SP2 is downloaded after March 05 2007 then the hotfix is not required.
Could someone give proper information on this... someone who has actually upgraded to SP2.
ThankYou
"Keep Trying"

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 1

Chirag,

if you had downloaded SP2 after March 05 2007 then everything is fine.....if you have the previous SP2 released b4 it you will face some issues with maintenace cleanup task...refer, http://support.microsoft.com/kb/933508/

This is the latest one after march 05 the 2007, http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

[font="Verdana"]- Deepak[/font]

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

ChiragNS

One Orange Chip

Points: 26137

August 10, 2007 at 4:12 am

#725935

by the way have you done this...

"Keep Trying"

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Deepak

Thanks for your reply. Does that mean that i download SP2 and install it... nothing else to be done.....

"Keep Trying"

Vegard Hagen Hall of Fame Points: 3078 More actions · Answer 4

In my opinion, Microsoft is not very good at helping us keep track of all their new versions, releases, service packs and hotfixes - it's more or less a jungle out there.

Here's what I do and I've done this about 15 times over the past 4 months:

First I install SP2, downloaded April 20. 2007 (KB921896, version 9.00.3042).

Then I install the Hotfix KB934459, also downloaded April 20. 2007. This brings the SQL Server instance up to version 9.0.3159. I guess you don't really have to do this, but I figure if you're upgrading anyway, you might as well get something close to the latest version while you're at it.

Kind regards,

Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

It is better to light a candle than to curse the darkness. (Chinese proverb)

Vegard Hagen Hall of Fame Points: 3078 More actions · Answer 5

Quote:

"This is the latest one after march 05 the 2007, http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en "

Actually no, it's not. That's version 9.00.3050. I have 9.0.3159 and there are newer versions after that one as well. Like I said, Microsoft is not doing a very good job of helping people keep track of these things.

Kind regards,

Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

It is better to light a candle than to curse the darkness. (Chinese proverb)

ChiragNS One Orange Chip Points: 26137 More actions · Answer 6

Vegard Hagen

Thanks for your response.

Regards

"Keep Trying"