Antwort Is SQL Server 2016 still available? Weitere Antworten – Is Microsoft SQL 2016 still supported

Is SQL Server 2016 still available?
For SQL Server 2019 on Windows The release is supported at the SQL Server 2019 on Windows RTM Release version. The release is supported at the SQL Server 2017 on Windows RTM Release version. SQL Server 2016 and older versions are not supported on Windows Server 2022 or Windows 11.Is Windows 2016 end of support The end support for Windows Server 2016 on 11/01/2022. After this date, the server no longer receives certain updates, but security updates are still available. The Windows Server 2016 extended support end date, which lasts until 11/01/2027, only includes security updates.Latest updates available for currently supported versions of SQL Server

Version Latest service pack
SQL Server 2016 – Build information – Installation Azure Connect pack (13.0.7000.253 – May 2022) SP3 (13.0.6300.2 – September 2021) SP2 (13.0.5026.0 – April 2018) SP1 (13.0.4001.0 – November 2016)

Is SQL Server 2014 still in support : This means that SQL Server 2014 will no longer receive any general updates, but only the security updates. The extended support lasts, just as the Mainstream support, around 5 years and will therefore end on July 9, 2024.

How long will SQL Server 2016 be supported

SQL Server EOL Overview

Version EOL Date Extended security update option
SQL Server 2014 Jul 9, 2024 No
SQL Server 2016 Jul 14, 2026 No
SQL Server 2017 Oct 12, 2027 No
SQL Server 2019 Jan 8, 2030 No

Can you upgrade SQL 2016 to 2019 : You can perform the upgrade from DVD, from a mounted ISO, or from files extracted from an ISO image. Direct upgrades from SQL Server version prior to 2016 are not supported.

Windows Server 2016's mainstream support expired on 11/01/2022. After this date, the server does not receive some updates. The security and security updates are however still there! This is because of the extended support, which lasts until 11-01-2027.

Microsoft Windows Operating Systems

Windows Server version Edition EOL Date
Windows Server 2016 Datacenter January 12, 2027
Standard January 12, 2027
Essentials January 12, 2027
Windows Server 2012 R2 Datacenter October 10, 2023

Which versions of SQL Server are still supported

Overview

Version Release Date End of Mainstream Support
SQL Server 2016 06/01/2016 07/13/2021
SQL Server 2017 09/29/2017 10/11/2022
SQL Server 2019 11/04/2019 02/28/2025
SQL Server 2022 11/16/2022 01/11/2028

The current version is Microsoft SQL Server 2022, released November 16, 2022. The RTM version is 16.0. 1000.6.SQL Server Support dates

Version Release Date End of Mainstream Support
SQL Server 2022 16-11-2022 11-01-2028
SQL Server 2019 04-11-2019 07-01-2025
SQL Server 2017 29-09-2017 11-10-2022
SQL Server 2016 01-06-2016 13-07-2021


SQL Server End of Life Dates

SQL Server Product Mainstream Support End Date Extended Support End Date
SQL Server 2016 Jul 13, 2021 Jul 14, 2026
SQL Server 2017 Oct 11, 2022 Oct 12, 2027
SQL Server 2019 Jan 7, 2025 Jan 8, 2030
SQL Server Management Studio Continued support in line with Microsoft's Modern Lifecycle Policy

Can we install SQL Server 2016 and 2019 on same machine : Yes, it's possible to run multiple versions of Microsoft SQL Server on the same machine without major issues. Each version can operate independently, using separate instances and ports.

How to migrate SQL 2016 to 2022 : Procedure

  1. To upgrade a previous version of SQL Server to SQL Server 2022 Express software, click this link, download and run SQLEXPR_x64_ENU.exe.
  2. In the SQL Server Installation Center window, click Installation.
  3. In the right pane, click Upgrade from a previous version of SQL Server.

What happens when Windows Server 2016 license expires

you will observe the message: “License has expired”. This will shut down the server and even if you turn on the server again, it will shut down after an hour.

It's important to note that running Windows Server without a license is not recommended for production environments. Microsoft offers a 180-day evaluation version specifically for testing purposes. If you go over 180 days, the server will start shutting down regularly until you license it.Aging Server Nearing the End of Its Lifecycle

Some IT professionals recommend replacing small business servers every 4-6 years. The traditional industry standard for server replacement has been 3-5 years, depending on usage.

What is the lifespan of a server : Surprisingly servers last much longer than most people think. Oftentimes, users think the server refresh time is determined by the OEM, typically when the server is between 3-5 years old. According to an analyst firm's findings, the likely lifespan of servers is within 7-10 years.