question

DaniSQL avatar image
DaniSQL asked

Applying Cumulative Update Packages

Hello there,

I just installed Sql Server 2005 and applied sp3 to it. Now I want to apply the cumulative update packages but Im not sure If I have to apply all of them or the last one is enough. If I apply sp3 i know i dont have to apply sp2 and sp1. but if I apply cumulative update package 7 does that mean i dont need to apply the first 6 packages? If I have to install all, inwhat order? Please advise.

Thanks!

sql-server-2005service-pack
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Matt Whitfield avatar image
Matt Whitfield answered

A cumulative update package can be installed standalone - it's in the name really.

From MSDN:

Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server fix release.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image Blackhawk-17 commented ·
Just be sure to read the warnings and disclaimers on CUs!
1 Like 1 ·
Grant Fritchey avatar image
Grant Fritchey answered

+1 to what Matt says, plus this. Make sure you test the install on a system that does not contain your production data (or better still, contains a copy of your production data) prior to applying it to your production system. This should apply to any service pack or hot fix. You can't possibly be paranoid enough about these things.

7 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
+1 - not seen one fail for a looooong time but you never know.
1 Like 1 ·
DaniSQL avatar image DaniSQL commented ·
Thanks Grant. Its a brand new server and there is no production data on it. But How can I test the install ? what signs should i look for if there is sth wrong?
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Oh, you'll know, very quickly. In my experience it's one of two things, the server won't come online or one or more databases won't come online. With a new install and no databases, the number of errors is pretty radically reduced.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Fatherjack, remember SQL Server 6.5 sp5 & sp5a? My scars still haven't healed. I install the sp's & cu's, but I'm very wary of them.
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
You are right. The server wont come online and after I restarted it twice it comes online again. I havent added any databases to this instance yet. Do u thing it is safe to use it for production now?
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Restarting because of the sp & cu? If so, it's probably just fine. If not, I'd run DBCC checks on the system databases & be sure to do a good test prior to releasing it for production use.
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
Thanks! Seems everything is fine so far.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.