Originally reported by devclass.com. Published July 2019.
SQL Server 2008 and 2008 R2 Reach End of Support
On July 9, 2019, Microsoft officially ended mainstream and extended support for SQL Server 2008 and SQL Server 2008 R2. After more than a decade in production environments worldwide, the two database versions stopped receiving security patches, bug fixes, and technical support under Microsoft’s standard lifecycle policy.
John Chirapurath, General Manager for SQL Server and Azure Data + AI at Microsoft, marked the milestone with a blog post thanking customers “for the ten amazing years we’ve had together” while simultaneously directing them toward Microsoft’s Azure-based alternatives.
Migration Options Microsoft Offered
Microsoft laid out three primary paths for customers still running SQL Server 2008 or 2008 R2 at end of support:
- Migrate to Azure SQL Database (managed service): Microsoft positioned this as “evergreen SQL,” arguing that customers moving workloads to its fully managed platform would no longer need to manage patching, version upgrades, or future end-of-support deadlines. Microsoft also cited security improvements and elastic scalability as key benefits of the managed service.
- Rehost on Azure Virtual Machines: Customers who were not ready to move to a fully managed database service could lift and shift their existing SQL Server 2008 or 2008 R2 instances onto Azure Virtual Machines. Microsoft promised this path would require “few or no application code changes” and, critically, would grant an additional three years of free Extended Security Updates (ESUs).
- Purchase Extended Security Updates on-premises: Organizations that needed or wanted to keep their databases on-premises could purchase three additional years of “critical” security updates only. This option was positioned as a last resort, with Microsoft clearly favoring the cloud migration paths.
New Azure SQL Services Announced Alongside the Cutoff
Alongside the end-of-support announcement, Microsoft used the moment to preview new SQL-related services on Azure:
- Unified Azure SQL Management Portal: A simplified portal experience allowing administrators to manage both Azure SQL Database and SQL Server on Azure Virtual Machines from a single interface. This feature entered preview at the time of the announcement.
- SQL Server Big Data Clusters: A preview feature that integrated SQL Server with Apache Spark and Hadoop, enabling organizations to work with relational and non-relational data side by side within a single platform.
Expanded Storage for Azure Database for MySQL and PostgreSQL
In a related announcement, Microsoft also previewed “large storage” tiers for Azure Database for MySQL and Azure Database for PostgreSQL. Both offerings added support for up to 16 TB of storage and up to 20,000 IOPS, targeting high-throughput, large-scale workloads that had previously required more complex infrastructure arrangements.
What This Meant for Database Administrators
For DBAs and DevOps engineers still running SQL Server 2008 environments in mid-2019, the end of support created a genuine security and compliance risk. Without ongoing security patches, any newly discovered vulnerabilities would remain unpatched unless organizations took one of the three paths Microsoft outlined.
The free Extended Security Updates available to Azure VM customers represented a meaningful incentive: teams that could not immediately re-architect their applications gained up to three additional years to plan a proper migration, without sacrificing security updates. On-premises ESU customers faced the same three-year window but had to pay for the privilege and received only critical-severity patches.
For teams evaluating migration options at the time, Microsoft’s messaging made the Azure VM lift-and-shift path the lowest-friction short-term option, while Azure SQL Database represented the longer-term strategic target for workloads that could be adapted to a managed service model.
Key Takeaways
- SQL Server 2008 and 2008 R2 reached end of extended support on July 9, 2019.
- Customers migrating to Azure Virtual Machines received three additional years of free Extended Security Updates.
- On-premises customers could purchase ESUs covering critical patches only for three years.
- Azure SQL Database was promoted as a fully managed, “evergreen” alternative requiring no future upgrade planning.
- Microsoft simultaneously launched previews of a unified SQL management portal, SQL Server Big Data Clusters, and large-storage tiers for Azure Database for MySQL and PostgreSQL.