|
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".
(comments are locked)
|
|
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. 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 '10 at 03:13 AM
Håkan Winther
Yes I'm talking about a CTP of a Service Pack. Thanks Aaron
Feb 11 '10 at 09:34 PM
Kevin Newton
(comments are locked)
|
|
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? 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 '10 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 '10 at 09:37 AM
Grant Fritchey ♦♦
(comments are locked)
|
|
I dont know about CTP but I recently updated one SQL2005 RTM+ instance directly to SQL2005 sp3 and everything works fine. 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 '10 at 05:05 AM
David Wimbush
(comments are locked)
|
