Category Archives: Management

SQL Server Lifecycle

I have been in several meetings discussing the need to move off of SQL Server 2005.  Below are the support end dates for the primay SQL Server versions and a link to get update information for new versions.  As you can see, mainstream support for SQL Server 2005 ended in 2011.  Extended Support for SQL Server 2005 ends on 4/12/2016.

Important Dates for SQL Server:
10/08/2013 SP2 is required for support for SQL Server 2008 R2
01/14/2014 SP1 is required for support of SQL Swerver 2012
07/08/2014 SQL Server 2008 and 2008 R2 mainstream support ends
04/12/2016 SQL Server 2005 Extended support ends
07/11 2017 SQL Server 2012 mainstream support ends

 

Products Released Lifecycle Start Date Mainstream Support End Date Extended Support End Date Service Pack Support End Date Notes
SQL Server 2005 Compact Edition 2/19/2007 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Developer Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Enterprise Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Enterprise Edition for Itanium-based Systems 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Enterprise X64 Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Express Edition 6/1/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Express Edition with Advanced Services 7/16/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Standard Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Standard Edition for Itanium-based Systems 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Standard X64 Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Workgroup Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2008 Developer 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Enterprise 11/7/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Express 11/11/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Express with Advanced Services 11/22/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 R2 Datacenter 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Developer 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Enterprise 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Express 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Express with Advanced Services 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Parallel Data Warehouse 11/9/2010 7/8/2014 7/9/2019 Hardware products will receive 5 years of support following Microsoft’s end of sales date for the Major Product version. Minor Product releases follow the Support Lifecycle of their respective Major Product versions.
SQL Server 2008 R2 Standard 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Standard Edition for Small Business 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Web 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Workgroup 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 Standard 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Standard Edition for Small Business 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Web 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Workgroup 11/6/2008 7/8/2014 7/9/2019 4/13/2010