--- title: SQL Server 2008/R2 End Of Support.  Is this An Opportunity To Modernize? description: The time is right to upgrade, migrate and modernize legacy SQL Server 2008/R2 workloads. On July 9, 2019 Microsoft will no longer support these servers. image: https://blog.gobiztech.com/hs-fs/hubfs/SQL%20Server%202008%20end%20of%20support.png?width=600&name=SQL%20Server%202008%20end%20of%20support.png --- [![AMTRA-ID](https://www.amtrasolutions.com/hubfs/AMTRA-ID.png)](https://www.amtrasolutions.com) - Modern Work - [Overview](https://www.amtrasolutions.com/modern-work) - [Microsoft 365](https://www.amtrasolutions.com/microsoft-365) - [Copilot for M365](https://www.amtrasolutions.com/copilot-for-m365) - [Compliance](https://www.amtrasolutions.com/compliance) - Security & Cloud - [Licensing](https://www.amtrasolutions.com/licensing) - [Overview](https://www.amtrasolutions.com/security-cloud) - [Data & AI Business Insights](https://www.amtrasolutions.com/ai-business-insights) - [Modern Endpoint](https://www.amtrasolutions.com/modern-endpoint) - [Security](https://www.amtrasolutions.com/security) - [Cloud](https://www.amtrasolutions.com/cloud) - [Digital & App Innovation](https://www.amtrasolutions.com/digital-app-innovation) - [Digital Workplace Adoption](https://www.amtrasolutions.com/adoption-change-management-solution) - [Learn](https://www.amtrasolutions.com/blog) - Company - [About Us](https://www.amtrasolutions.com/about-us) - [Leadership](https://www.amtrasolutions.com/leadership) - [Events](https://www.amtrasolutions.com/events) - [Careers](https://www.amtrasolutions.com/careers) [Talk to an expert](https://www.amtrasolutions.com/contact) security # SQL Server 2008/R2 End Of Support.  Is this An Opportunity To Modernize? The time is right to upgrade, migrate and modernize legacy SQL Server 2008/R2 workloads. On July 9, 2019 Microsoft will no longer support these servers. [AMTRA Solutions](https://www.amtrasolutions.com/blog/author/amtra-solutions) May 28, 2019 --- Sometimes in life we need an upgrade to take advantage of the latest and greatest.  And technology is no different.  We’re referring to SQL Server 2008/R2 which is reaching end of support.  On July 9, 2019 Microsoft will no longer support these servers.   **Why does this matter?** Well, first off the end of SQL Server 2008/R2 can have serious implications for your business, and you need to take action to ensure your business is not vulnerable to security threats. Did you know that unpatched servers are a considerable risk to an organization’s security? In fact, in 2017, the [most massive security breach](https://money.cnn.com/2017/12/18/technology/biggest-cyberattacks-of-the-year/index.html) documented affected 140 million users and was caused by an unpatched server. **What are your options?** Thankfully, you have several options as Microsoft has allowed for various scenarios depending on what is best for your business and its current and future state. AMTRA can help you determine what scenario is best for you. Here are some choices.  - ***Migrate to Azure Managed Instance and get benefits of a fully managed SQL Server offering***End of support is an ideal time to transform your IT environment with the cloud. You can move your SQL Server 2008, and 2008 R2 deployments with no application code change and near-zero downtime to Azure SQL Database Managed Instance. This is a fully-managed PaaS solution with near 100% compatibility to your on-premises SQL Server, which provides automatic patching, version updates, high-availability and automatic backups so that you can focus on your business data rather than spending cycles managing your SQL Servers. - ***Migrate to Azure IaaS and benefit from three years of extended security updates and instant computing infrastructure*** For situations where you are running critical legacy applications on SQL Server 2008 that cannot be upgraded but are still required for business operations, Microsoft gives you the option to migrate to your VMs to the Azure Cloud platform and receive three years of extended security updates to SQL 2008. Doing so allows you to reuse your existing licensing and gives the organization the time and flexibility to map out your upgrade plan to either a new version of SQL or Azure Managed Instance. - ***Upgrade on-premises environments and stay protected*** For apps and data that you want to keep running on-premises, its recommended that you upgrade to SQL Server 2017 to get improved data management features with strong security. SQL Server 2017 is the new standard for performance and efficiency and includes built-in security features to protect your business. For on-premises servers that need more time to upgrade, you will be able to purchase Extended Security Updates for three more years if you need to keep running your SQL databases on SQL 2008/2008 R2. ## **The time is right to upgrade, migrate and modernize legacy workloads.** There has not been a better time to migrate and modernize legacy workloads in the cloud. You can expect to gain operational efficiency, reduce infrastructure and licensing costs, and empower your development teams with the tools to deliver value faster to their business.  Contact one of our cloud experts today [info@amtrasolutions.com](mailto:info@amtrasolutions.com). Photo credit | https://blog.gobiztech.com/sql-server-2008-end-of-support [security](https://www.amtrasolutions.com/blog/tag/security) [Microsoft](https://www.amtrasolutions.com/blog/tag/microsoft) [sql server](https://www.amtrasolutions.com/blog/tag/sql-server) ## Similar posts Microsoft ### [Ending Soon | Microsoft support for SQL Server 2008/R2](https://www.amtrasolutions.com/blog/sql_end_of_life) Running on end of support software means your organization will no longer receive security updates, making the risks of security and compliance... AMTRA Solutions Jul 5, 2019 Microsoft ### [End-of-Support for SQL Server 2008 Is Approaching Fast!](https://www.amtrasolutions.com/blog/sql_server_2008_end_of_support) SQL Server 2008 and R2 are finally getting the boot! What are you going to do about it? AMTRA Solutions Jun 19, 2019 Microsoft ### [End-of-Support for SQL Server 2012](https://www.amtrasolutions.com/blog/sql_server_2012_end_of_support-0) SQL Server 2012 is finally getting the boot! What are you going to do about it? AMTRA Solutions Jul 22, 2022 ### Get notified on new marketing insights Be the first to know about new B2B SaaS Marketing insights to build or refine your marketing function with the tools and knowledge of today’s industry. ![AMTRA Logo\_white](https://www.amtrasolutions.com/hs-fs/hubfs/Icons%20and%20Logos/AMTRA%20Logo_white.png?width=2417&height=846&name=AMTRA%20Logo_white.png) # 855.326.0533 [info@amtrasolutions.com](mailto:info@amtrasolutions.com) [![Blogger-Icon-ok](https://www.amtrasolutions.com/hubfs/Blogger-Icon-ok.png)](https://www.amtrasolutions.com/blog)        **Vancouver       •       Calgary       •       Saskatoon       •       Toronto       •       Montreal**  © 2023 Amtra Solutions All rights reserved           [Privacy Policy](https://www.amtrasolutions.com/privacy-policy)[Terms and Conditions](https://www.amtrasolutions.com/terms_conditions)