Can SQL2005 SP3 be applied to...

Can SQL2005 SP3 be applied to SQL2005 that is at level: 9.00.2040 SP 1 Mar 2006 CTP? A fellow DBA is saying that you cannot apply SP3 to a "CTP".

more ▼

asked Feb 05, 2010 at 03:30 PM in Default

avatar image

Kevin Newton
23 1 1 3

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

I think you guys are confusing a CTP of SQL Server with a CTP of a SQL Server Service Pack (a pre-release CTP of SQL Server 2005 would have a build <= 9.00.1399). I think you should be able to apply SP3 to that build (9.00.2040) no problem.

more ▼

answered Feb 08, 2010 at 06:49 PM

avatar image

Aaron Bertrand
36 2 1

(comments are locked)
10|1200 characters needed characters left

I agree with him. I wouldn't apply the SP to a CTP either. As a matter of fact, I would strongly suggest that, 5 years since the release of 2005, it's probably time to get rid of the CTP.

Is it possible to do? Sure. But you're looking at the strong possibility of unknown effects. Why take chances?

more ▼

answered Feb 05, 2010 at 05:27 PM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

I'm not talking about a CTP of the actual SQL engine. I'm talking about a Service Pack CTP...9.00.2040. 2040 being the Service Pack CTP released in Mar 2006

Feb 11, 2010 at 09:36 PM Kevin Newton

That makes some difference, but not tons. I'm still nervous about applying approved SP's to test SP's, but... I'd get the system upgraded,regardless of where it's at now.

Feb 12, 2010 at 09:37 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

I dont know about CTP but I recently updated one SQL2005 RTM+ instance directly to SQL2005 sp3 and everything works fine.

more ▼

answered Feb 07, 2010 at 10:58 PM

avatar image

4.9k 33 39 43

Yes, a service pack includes all previous service packs for the product. So yu can install the RTM and then service pack 3 and you have all patches from service packs 1 & 2 included. It's the same with the Books Online service packs.

Feb 08, 2010 at 05:05 AM David Wimbush
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 05, 2010 at 03:30 PM

Seen: 1266 times

Last Updated: Feb 05, 2010 at 03:30 PM

Copyright 2018 Redgate Software. Privacy Policy