Is SP2 required for installing SP3

Question

Is SP2 required for installing SP3

Arun Benjamin

SSCommitted

Points: 1614
More actions
January 8, 2009 at 12:39 am

#129947

Hi,
I am planning to install SP3 in a new SQL 2005 instance, not sure of this one but. Can we install SQL 2005 and apply the SP3 directly, or should we apply SP2 first?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mr James Howard Ten Centuries Points: 1158 More actions · Answer 1

Hi,

Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. You do not have to install a previous service pack before you install the latest one.

http://www.sqlhowto.co.uk/post/how-can-i-get-sql-server-2005-service-pack-3-.html

James Howard

Jerry Hung SSChampion Points: 12968 More actions · Answer 2

James' answer is good

short answer is NO, SP1/SP2 is not required for SP3 install

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Arun Benjamin SSCommitted Points: 1614 More actions · Answer 3

James and Jerry,

Thanks a lot for the reply. I am now getting prepared to install SP3 directly 🙂