End of Mainstream support for SQL Server 2008 and SQL Server 2008 R2

End of Mainstream support for SQL Server 2008 and SQL Server 2008 R2

Rate This
  • Comments 8

We would like to remind all customers that Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 has ended on July 8, 2014. Microsoft is ending support for these products as part of our Support Lifecycle policy, found in http://support.microsoft.com/lifecycle

Customers are encouraged to prepare and execute on their upgrade and/or sustained engineering plans as early as possible for these SQL versions.  Remaining current on your SQL Server version ensures that your product remains supported per the Support Lifecycle policy. 
Additionally, your software benefits from the many enhancements, fixes, and security updates provided through the latest releases.

For both SQL Server 2008 and SQL Server 2008 R2, Microsoft will continue to provide technical support which also includes security updates during the duration of extended support.  See the table below for extended support end date.  Non-security hotfixes for these versions will be offered only to customers who have an Extended Hotfix Support agreement.  Please refer to Extended Hotfix Support – Microsoft for more information.


Products Released

Lifecycle Start Date

Mainstream Support End Date

Extended Support End Date

Service Pack Support
  End Date

SQL Server 2008





SQL Server 2008 Service Pack 1


Not Applicable

Not Applicable


SQL Server 2008 Service Pack 2


Not Applicable

Not Applicable


SQL Server 2008 Service Pack 3


Review Note

Review Note


SQL Server 2008 R2





SQL Server 2008 R2 Service Pack 1


Not Applicable

Not Applicable


SQL Server 2008 R2 Service Pack 2


Review Note

Review Note




Leave a Comment
  • Please add 8 and 2 and type the answer here:
  • Post
  • and the announced Service Packs for these two version, mean what for main stream support?

  • Hello,

    This is nice blog. If you have some issues with microsift then You can find solution on http://pcstartech.us/  

  • If you follow your CU schedule 2008 SP4 could be out this month and 2008R2 SP3 next month. Can we get an indication of when these service packs will actually appear please?



  • We are using sql2008 r2 database and after the shrink database, .ldf file (Log file) size not reduce. Can anyone help?

  • can the table be updated to include the latest releases of SP3 and SP4 for SQL 2008 and 2008 R2 respectively?

  • Might be paid service tagged under extended support

  • PFA for updated information also please correct me if any wrong information is there in the blog


  • I have a problem on MS SQL2008r2:


    ApplicationExperienceInfrastructure" warning when you try to install the Directory Sync tool in Windows Server 2012

Page 1 of 1 (8 items)