Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am little lost in touch whit few SQL servers regarding to their updates.
Now I want to update these serves and I see that now is actual SP4 for SQL2005 databases.
My question is:
If I skip SQL Service pack 2 or 3 and just install Service pack 4 do I have latests updates for all sql components , also do I need to install and others service packs beside of SP4 ?

share|improve this question

1 Answer 1

up vote 4 down vote accepted

SQL Service Packs, like Windows Service Packs, are cumulative. That is, they supersede older ones and have all prior updates in them. You only need to install SP4.

Beyond SP4 you could do Cumulative Updates or "CU's" that are "all small updates since last Service Pack". Most people only do Service Packs though, which are more thoroughly tested then CU's.

this may help you understand difference between hotfixes, CU's, SP's http://support.microsoft.com/kb/935897

Newest CU for SQL 2005 SP4: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/12/20/cumulative-update-1-for-sql-server-2005-service-pack-4.aspx

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.