Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Limited support options might be available for certain versions of SQL Server


View products that this article applies to.

Summary

The Microsoft Support Lifecycle policy requires that the product’s supported service pack be installed to continue to receive all applicable support options. Depending on the version and the build number, your instance of Microsoft SQL Server might only be eligible for limited support. When you encounter a problem with instances of SQL Server that are under limited support, you only receive limited troubleshooting support from Microsoft. Technical workarounds may be either limited or nonexistent under such situations. Additionally, you cannot obtain hotfix support.

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.

↑ Back to the top


More Information

To obtain complete information about the support lifecycle status for your specific version of SQL Server and service pack, visit the following Microsoft website
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.

Support LifeCycle for SQL Server 2008

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 softwareRule titleRule descriptionRegistry path
System Center AdvisorSQL Server version is under limited supportSystem 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
The Microsoft Support Lifecycle website contains explanations for the different dates: General Availability, Mainstream Support End, Extended Support End, and Service Pack Support End. For more information, you can also visit the following links:Additional referencesAdditional references

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 2443518
Revision : 3
Created on : 11/20/2019
Published on : 11/20/2019
Exists online : False
Views : 332