Microsoft Warns of SQL Server 2008 End of Support in Less than a Year

In less than a year, Microsoft will end support for SQL Server 2008, meaning no more updates and no more support, but perhaps more problems on the security and compliance fronts for organizations that don't migrate to newer options.

After a 10-year run, Microsoft is giving enterprises plenty of time and plenty of advice on how to deal with swapping out their entrenched SQL Server 2008 and SQL Server 2008 R2 installations, preferably to the Azure cloud (where the upcoming Azure SQL Database Managed Instance is an option) or the latest on-premises version, SQL Server 2017.

"End of support means the end of regular security updates," said Microsoft exec Takeshi Numoto in a blog post last week. "With cyberattacks becoming more sophisticated and frequent, running apps and data on unsupported versions can create significant security and compliance risks. The 2008 family of products was great for its time, but we highly recommend upgrading to the most current versions for better performance, efficiency, and regular security updates."

Microsoft is recommending two options for enterprise upgrades: migrating to the Azure cloud or doing an in-premises upgrade.

With the preferred Azure option, the company is offering free Extended Security Updates to help secure 2008, R2 and Windows Server workloads for three more years after the July 9, 2019, end-of-support cut-off, recognizing "that it can be hard to upgrade everything before the end of support timeline." Support ends for Windows Server 2008/2008 R2 on Jan. 14, 2020

"You can also move your SQL Server 2008 and 2008 R2 deployments with no application code change and near zero downtime to Azure SQL Database Managed Instance," Numoto said. "It is a fully-managed database-as-a-service solution with industry leading SLAs and does not require future upgrades. Azure SQL Database Managed Instance will be generally available in early Q4 of this calendar year."

Extended Security Updates will also be available for on-premises upgrades, but only for purchase and only by organizations with Software Assurance or Subscription licenses under an Enterprise Agreement enrollment.

The company provides detailed information on the upgrades in its 2008 End of Support Resource Center. That site guides organizations in finding a migration partner or undertaking the task themselves with a three-step process: assess, migrate and optimize.

More information on end-of-support options is also available in a July 12 webinar that is available on-demand.

About the Author

David Ramel is an editor and writer for Converge360.

comments powered by Disqus


  • What's New in Visual Studio 2019 v16.5 Preview 2

    The second preview of Visual Studio 2019 v16.5 has arrived with improvements across the flagship IDE, including the core experience and different development areas such as C++, Python, web, mobile and so on.

  • C# Shows Strong in Tech Skills Reports

    Microsoft's C# programming language continues to show strong in tech industry skills reports, with the most recent examples coming from a skills testing company and a training company.

  • Color Shards

    Sharing Data and Splitting Components in Blazor

    ASP.NET Core Version 3.1 has at least two major changes that you'll want to take advantage of. Well, Peter thinks you will. Depending on your background, your response to one of them may be a resounding “meh.”

  • Architecture Small Graphic

    Microsoft Ships Preview SDK, Guidance for New Dual-Screen Mobile Era

    Microsoft announced a new SDK and developer guidance for dealing with the new dual-screen mobile era, ushered in by the advent of ultra-portable devices such as the Surface Duo.

  • How to Create a Machine Learning Decision Tree Classifier Using C#

    After earlier explaining how to compute disorder and split data in his exploration of machine learning decision tree classifiers, resident data scientist Dr. James McCaffrey of Microsoft Research now shows how to use the splitting and disorder code to create a working decision tree classifier.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events