SQL Server 2005 Upgrade - Service pack 2

Question

SQL Server 2005 Upgrade - Service pack 2

naumangee

SSC Enthusiast

Points: 117
More actions
July 3, 2009 at 8:42 am

#211874

Dear All,
I have SQL SERVER 2005 Entrprise Edition on the Windows Server 2003(operating system).
I need to upgrade the SQL server 2005 to Service pack 2.
Currently I have SQL SERVER 2005 initial version. "9.00.1399.06".
My question is, can I apply the service pack 2 directly? or do I need to apply the service pack 1 first and then apply the service pack 2?
Many Thanks in advance
Nauman

Viewing 7 posts - 1 through 6 (of 6 total)

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

Lowell SSC Guru Points: 323504 More actions · Answer 1

service packs are cumulative...so everything that was in SP1 is also in SP2, and everything that was in SP1 and SP2 exists in Service pack 3, so you only need to run the latest you wish to install.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mohd.sql Old Hand Points: 384 More actions · Answer 2

After applying SQL Server 2005 SP1 to SP2 .....

how to check the current version...

select @@version show the updated version....

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

As Lowell stated, service packs are cumulative. Question though, why not upgrade to service pack 3? It is the current service pack for 2005?

Joie Andrew
"Since 1982"

Lowell SSC Guru Points: 323504 More actions · Answer 4

old post Joie; someone must have run a search and replied to the thread today; i last posted on this thread July of 2009;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ssegereise Valued Member Points: 67 More actions · Answer 5

I can no longer open my database its needs MS Sql SERVER Beta 2 how do i get it

Lowell SSC Guru Points: 323504 More actions · Answer 6

ssegereise (4/4/2012)
I can no longer open my database its needs MS Sql SERVER Beta 2 how do i get it

databases all by themselves are independant of service packs.

only system databases(master,model,msdb) are restorable only to teh specific version.

What, exactly, is the error you are getting? I'm sure it's not depednant of service packs, but some other issue.

also, this thread is a bit old, you might want to add a new post instead.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!