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".
asked
Can SQL2005 SP3 be applied to...
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.
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
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.
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.
