Home / server / Questions / 245466
Accepted
adopilot
Asked: 2011-03-10 15:38:03 +0800 CST

If install SQL Service pack 4 on SQL2005 instance do I need to install also earlier SPs

  • 772

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 ?

sql-server-2005 sql update service-pack

1 Answers

  1. Best Answer

    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

    • 5