Say Goodbye to SQL Server 2008 & 2008 R2

In SQL by Dave RogersLeave a Comment

If your organization is using Microsoft SQL Server 2008 R2, then you have entered into the Microsoft world of ‘End of Extended Support’. Actually, SQL Server 2008 and 2008 R2 are in the extended support phase of their life cycle. What does this term mean for enterprises using SQL Server 2008 R2?

Recently, Microsoft announced SQL Server 2008 R2 extended support will end on July 9th ,2019. It means Microsoft will not accept requests for warranty, its change system support, changes in design, or new features during extended support phase. In short, no security updates for any version of SQL Server 2008 or R2 will be released.

The mainstream support was already ended for SQL Server 2008 and SQL Server 2008 R2. Adding to it, Windows Server 2008 and 2008 R2 will be no longer supported by Microsoft on Jan, 2020. Although, extended support will continue for a while, so it is the right time to take steps to upgrade the SQL Server 2008 version for high protection and risk management.

End of Extended Support – Know The Real Meaning

Every single product has its own life cycle. Extended Support is the last phase of any product life span. When an extended support ends, there will be no new features and security updates provided to that product.

As a result anyone still using SQL Server 2008 after the end of support will have at risk. Because cyber attacks become more active on unsupported versions that have a great risk on security and compliance. Therefore, it is highly recommended to the customers either they upgrade to a newer version of SQL Server or move to different platforms for better performance and high security.

Upgrade Windows Server 2008 and Windows Server 2008 R2 | Microsoft Docs

Benefits of Upgrading MS SQL Server 2008 and 2008 R2

  • Upgrade to SQL Server 2017 for greater security, performance, availability and innovation with cloud analytics
  • For continued protection beyond the deadline, buy up to three years of Extended Security Updates—cover only the workloads you need while you upgrade

Drawbacks of Not Upgrading SQL Server 2008

•Once the extended support deadline passes users will no longer able to receive any security updates for SQL Server 2008 and 2008 R2.

•Data could be at high risk after the end of extended support for SQL Server 2008.

What are the Migration Options Available for SQL Server 2008 users?

End of support options - SQL Server | Microsoft Docs

Depending on the requirement, you have a couple of options:

Move or Migrate SQL Server 2008 Workloads to Azure

  • Re host your SQL Server 2008 and 2008 R2 with few or no application code changes in Azure SQL Database Managed Instance for a “version-free” platform
  • Or, move to Azure Virtual Machines to get three years of Extended Security Updates at no additional charge and upgrade to a newer version when ready
  • Use existing licenses and save up to 55 percent with Azure Hybrid Benefit

Migrate to New SQL Server Version

  • Another option is to upgrade SQL Server 2008 to the new version of SQL Server 2019 if your software vendor supports this version. The advanced version provides reliability, enhanced performance, and tight security.
  • Users can also buy the extended security updates for the SQL Server or Windows Server 2008 or 2008 R2 after the end of support. So, the organization has three years to manage their workload.
  • Or one can go with SQL Server Database Migrator Tool to migrate database from SQL Server 2008 to 2017 & its below versions.

Leave a Comment