Announcing new options for SQL Server and Windows Server 2008 End of Support Article • 03/16/2020
| Product family | Windows |
|---|---|
| Document source | Lifecycle |
| Guide type | Reference Guide |
| Skill level | Intermediate to advanced |
| Time | 15 - 60 minutes depending on environment |
This page documents Announcing new options for SQL Server and Windows Server 2008 End of Support Article • 03/16/2020 for engineers working with Windows. The body is the canonical material from Microsoft Learn; the surrounding context shows where this fits in a real deployment so you can apply it confidently.
Reference content from Microsoft documentation
End-of-support work is the boring, unglamorous IT job that quietly saves companies from headline-grade breaches. I've spent the better part of seven years migrating workloads off Server 2008 R2, then 2012 R2, then SQL 2012 - and most of the lessons are the same. Announcing new options for SQL Server and Windows Server 2008 End of Support Article • 03/16/2020 is one of those notices you cannot ignore.
I've seen this fail when an enterprise treats EOL as a single migration sprint instead of a 6-9 month programme. Below is the practical playbook plus the canonical Microsoft framing, so you can plan a defensible exit before the support clock runs out.
SQL Server / Windows Server 2008 - the options
Microsoft has been deliberate about giving 2008 / 2008 R2 customers a paved road off the platform without rewriting code. The three honest options:
- Rehost to Azure VMs - gets you three years of free Extended Security Updates (ESU). This was the headline of the 2020 announcement and it is still useful for 2012 today.
- Upgrade in place to SQL Server 2019 or 2022, Windows Server 2022 or 2025. Slowest path because every bespoke app needs regression testing.
- Migrate to Azure SQL Managed Instance or Azure SQL Database. The most modernized option. Removes patch cycles entirely.
Cost frame I use in board decks
- Azure VM rehost: ~USD 700 / month per medium SQL workload (8 vCPU / 64 GB), about ₹58,000. Hybrid Benefit cuts that ~40%.
- Azure SQL MI General Purpose 8 vCPU: ~USD 1,260 / month (~₹1.05 lakh). Same hybrid benefit applies.
- Extended Security Updates on-prem: USD 75-300 per core per year for the final three years. Adds up fast for high-core SKUs.
# Migrate a database to Azure SQL MI using Azure Migrate
az migrate project create --resource-group rg-migrate --name sql-migrate-2026
# Then use Data Migration Service to actually move the DB
az dms project create --resource-group rg-migrate --service-name dms-sql --name proj1 --source-platform SQL --target-platform AZUREDBFORMI
Rollback and day-2 ops
- For every workload moved, keep a snapshot of the source system for at least 30 days. Cheap insurance.
- Document the migration runbook in your team wiki - including the exact CLI commands you ran, not paraphrased.
- Tag every migrated Azure resource with
migration-waveandsource-systemtags. Future-you will need them when costs spike.
What I watch after rollout
- Microsoft Defender for Cloud secure score for the new resources.
- Azure Cost Management for unexpected new charges - especially storage and egress.
- Application telemetry from the migrated workloads. Latency p95 should match or beat the on-prem baseline within two weeks.
Related work in your environment
- Cross-check the dates above with the official Microsoft Lifecycle Policy site; Microsoft does revise dates and we update this page on a rolling cadence.
- Document the EOL product list and its replacement path in your team's architecture review document.
- Schedule a quarterly lifecycle audit. It is the single cheapest control against last-minute migration panics.
FAQ
References
- Microsoft Learn - official documentation for Windows
- Microsoft tech community forums and Q&A
- Azure / Microsoft 365 service health dashboards
Related fixes
Related guides worth a look while you sort this one out:
- New options for SQL Server 2012 and Windows Server 2012 End of Support
- Support for Windows XP, Office 2003 and Exchange 2003 ended Article • 03/16/2020
- Windows Server 2008 R2 SP1
- Prepare now for end of support in 2019 and 2020
- Revised end of service date for Windows 10, version 1709: October 13, 2020
- Exchange Server 2010 support extended