As per http://support.microsoft.com/lifecycle/?p1=2855 SQL 2005 sp3 support ended 10/Jan/2012 and sp4 was released on 13/Dec/2010. The note against sp4 says
As there will be no sp5, does that mean that support for sp4 ended on 10/Jul/2007 ? !
Any advice (other than "What? you are still on SQL 2005?! You'd better upgrade") gratefully received.
asked Jan 23 '12 at 04:26 AM in Default
No read that as 'if there is another service pack, then the support for this one expires 12 months after that one starts'.
Support for SP4 therefore ends at the end of the "product's support lifecycle" which is 12 April 2011 for mainstream support, and 12 April 2016 for extended support.
It's MS's way of saying if you have a problem on SP3, then try SP4 before whinging!
answered Jan 23 '12 at 04:38 AM
Kev Riley ♦♦
From the Support Lifecycle Policy, http://support.microsoft.com/gp/lifepolicy:
So you've either got Release date of SQL2008 + 2 years, or release date of SQL 2005 + 5 years, whichever is later. Given SQL Server 2008 was generally available in Nov 2008, and SQL Server 2005 was generally available in Jan 2006, it seems as though they've gone for a "neither of the above" option. Typical. However, we have got a better deal than either of those blind calculations would give, as shown by the Product Lifecycle website.
Given that everything on the Lifecycle search results at http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=SQL+Server+2005&Filter=FilterNO shows mainstream support ending for the main product (not for the specific service packs) on 2011-04-12, then that's when mainstream support ended for SQL Server 2005.
answered Jan 23 '12 at 08:47 AM
In addition to @Kev Riley 's answer, just to clear the ambiguity that on 10/Jul/2007, the mainstream support for only RTM version (SP0) expired. But since SP1 was there, so if someone needed mainstream support then had to be on SP1 at that time. Same is the case now, if someone wants mainstream support for SQL Server 2005, then the user must be running instance with SP4.
Now what does the mainstream support for SP4 ends mean?