An operating-system lifecycle date and a database lifecycle date are separate planning inputs. Inventory both, along with application support, licensing and any extended-update agreement, before calling a workload unsupported.
Use the product-specific dates
| Product | Microsoft lifecycle milestone |
|---|---|
| SQL Server 2016 | Ordinary extended support ended July 14, 2026 |
| Windows Server 2016 | Extended support ends January 12, 2027 |
| Windows Server 2022 | Mainstream support ends October 13, 2026; extended support ends October 14, 2031 |
Check Microsoft's SQL Server 2016, Windows Server 2016 and Windows Server 2022 lifecycle pages for the relevant product. The end of mainstream support is different from the end of extended support.
SQL Server 2016 has Extended Security Updates options. Eligibility, acquisition and coverage must be checked for the installation; the ordinary support date does not establish that every SQL Server 2016 system has stopped receiving all security updates. Microsoft Extended Security Updates FAQ.
For remaining Windows Server 2012/R2 systems, check their separate program and entitlement dates. Do not assume the 2016 timeline applies to them.
Build a workload inventory
Record OS and database editions, builds, application versions, owners and support contracts. Include scheduled tasks, integrations, service accounts, certificates and backup tooling.
Identify the business consequence of an outage and the recovery requirements. Ask the application supplier to confirm a supported target configuration. An available operating-system upgrade does not establish that the hosted application supports it.
Compare migration options
Move to a newer supported platform: check application certification, hardware support, licenses and migration tooling before selecting a version.
Rebuild and migrate: a new environment can help separate configuration cleanup from cutover, but data transfer, testing and rollback still need planning.
Use an eligible extended-update program as a bridge: document its cost, limited scope, expiry and the migration work it enables. It is not a substitute for a target architecture.
Retire or consolidate: confirm that no users, integrations or retained records still depend on the service before removing it.
Choose hardware or cloud capacity from measured workload needs. Include storage performance, growth, availability and backup requirements, rather than copying the previous server specification.
Validate before cutover
- Test application functions and integrations on the chosen target.
- Rehearse data migration and record how changes during cutover are handled.
- Validate restore procedures and the rollback decision.
- Obtain business-owner acceptance with representative transactions.
- Update monitoring, asset records and support documentation.
- Decommission the old environment after the agreed retention and dependency checks.
Review any compliance or insurance conditions against the actual policy and applicable requirements. Avoid assuming one automatic outcome for every legacy system.
BustanTech's hardware and IT infrastructure services can support a scoped refresh. Discuss your workload inventory to establish a practical sequence.