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.


more ▼

asked Feb 16, 2010 at 11:43 AM in Default

avatar image

4.9k 33 39 43

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Feb 16, 2010 at 11:48 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

Just be sure to read the warnings and disclaimers on CUs!

Feb 16, 2010 at 12:13 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

+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.

more ▼

answered Feb 16, 2010 at 11:58 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

  • not seen one fail for a looooong time but you never know.

Feb 16, 2010 at 12:00 PM Fatherjack ♦♦

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?

Feb 16, 2010 at 12:19 PM DaniSQL

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.

Feb 16, 2010 at 12:35 PM Grant Fritchey ♦♦

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.

Feb 16, 2010 at 12:35 PM Grant Fritchey ♦♦

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?

Feb 16, 2010 at 01:02 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 16, 2010 at 11:43 AM

Seen: 3654 times

Last Updated: Feb 16, 2010 at 11:43 AM

Copyright 2018 Redgate Software. Privacy Policy