x

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

Kevin Newton gravatar image

Kevin Newton
23 1 1 1

(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

Aaron Bertrand gravatar image

Aaron Bertrand
36

You are right, I didn't read the question right. But I still don't think it is supported. All releases before SP2 has passed microsofts "mainstream support"
Feb 09, 2010 at 03:13 AM Håkan Winther
Yes I'm talking about a CTP of a Service Pack. Thanks Aaron
Feb 11, 2010 at 09:34 PM Kevin Newton
(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

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

DaniSQL gravatar image

DaniSQL
4.9k 33 35 39

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x28

asked: Feb 05, 2010 at 03:30 PM

Seen: 1145 times

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