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 ?

1 Answer 1


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .