To obtain full support, consider the following scenarios:
Case 1: If the version of your instance of SQL Server is still supported, you must update that instance to a supported service pack or to a hotfix build for that version. For more information, please see Additional references in the "More Information" section.
Case 2: If the version of your instance of SQL Server is not supported, you must first upgrade your instance of SQL Server to a supported version. Then, you must either apply the latest service pack that is available for that version, or you must at least apply the service pack version that is still supported.
For example, Microsoft SQL Server 2008 RTM entered limited support as of April 2010. This includes any hotfix builds that you applied from the SQL Server 2008 RTM servicing branch. If you have an instance of SQL Server that is at the RTM build level, we strongly advise you to upgrade the instance to a supported service pack level. We recommended that you upgrade to the latest service pack level. As of the writing of this article, the latest service pack for SQL Server 2008 is Service Pack 2.
Similarly, SQL Server 2008 SP1 enters limited support as of October 2011.
The following screen shot contains the support lifecycle information for SQL Server 2008 RTM, for SQL Server 2008 Service Pack 1, and so on. This screen shot is presented to demonstrate the kind of information that you can obtain from the support lifecycle website. You should always visit the support lifecycle website for current and accurate support lifecycle dates.
The following table provides more information about the products or the tools that check automatically for this condition on your instance of SQL Server and on the versions of the SQL Server product against which the rule is evaluated.
|Rule software||Rule title||Rule description||Registry path|
|System Center Advisor||SQL Server version is under limited support||System Center Advisor determines whether the instance of SQL Server is running on a build that is under limited support. If true, System Center Advisor generates a warning for this instance of SQL Server. Review the information that is provided in the “Information Collected” section of the advisor alert, and follow the resolutions that are provided in this article.||SQL Server 2008|
- Mainstream vs Extended Support and SQL Server 2005 SP4: Can someone explain all of this?
- Important SQL Server and Windows “End of Support” dates you should know about
- An important change for the Microsoft Lifecycle Support Policy
- Microsoft Support Lifecycle Service Pack Support Policy Revisions
- How to obtain the latest service pack for SQL Server 2008
- The SQL Server 2008 builds that were released after SQL Server 2008 was released
- The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released
- The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
- End of Mainstream Support for SQL Server 2005 and End of Service Pack Support for SQL Server 2008 SP1
Article ID: 2443518 - Last Review: Sep 20, 2011 - Revision: 1