ServicePacks in SQLServer

Question

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

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

mahesh.dasoni SSCommitted Points: 1653 More actions · Answer 1

For 2000 & 2005- SP4

For 2008 -SP2

For 2008R2- RTM (Release to Manufacture)

ravisamigo SSCertifiable Points: 7440 More actions · Answer 2

Thanks Mahesh.

Can I get answer for my question also please?

" In this " Microsoft SQL Server 2005 Service Pack 4 RTM " , what RTM is refers? "

Regards,

Ravi.

mahesh.dasoni SSCommitted Points: 1653 More actions · Answer 3

See Ravi RTM stands for RELEASE TO MANUFACTURE & there is nothing called Service pack 4 RTM.

RTM was used prior to Service pack 1

ravisamigo SSCertifiable Points: 7440 More actions · Answer 4

Thanks Mahesh.

Yes, RTM is prior to Servicepack 1.

But in the below link, I can see " Microsoft SQL Server 2005 Service Pack 4 RTM" as it's confusing me what RTM indicates here.

Regards,

Ravi.

FTdenali SSCertifiable Points: 5362 More actions · Answer 5

i would assume this simply means you can upgrade from RTM version straight to SP4 with prior to SP2 or SP3 installation.

mahesh.dasoni SSCommitted Points: 1653 More actions · Answer 6

In this link

Microsoft SQL Server 2005 Service Pack 4 RTM

--it means that SP4 has 1 more cumulative update which has build 9.00.5254 whereas service pack 4 has build 9.00.5000

Yes you can directly upgrade to Service pack 4 from RTM but it need to tested on UAT before applying to the production server

ravisamigo SSCertifiable Points: 7440 More actions · Answer 7

Now my doubt is cleared out.

Thank you all for your help !!

Regards,

Ravi.