Query on SQL services

Question

Hi

I am running Microsoft SQL 2016(SP3-GDR)(KB5021129) v13.0.6430.49 (X64) on Windows Server 2012R2. The VM is in Azure.I want to upgrade the VM to Windows Server 2019. Will this SQL version support Windows Server 2019.Are there any steps which needs to be taken care on SQL before and after the upgrade. experts guide me.

Answer 1

Yes, Win Server 2019 is fully supported by SQL Server 2016, see

https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver16

=> Operating System support for SQL Server 2016

Are there any steps which needs to be taken care on SQL before

As usually: Backup all databases, incl. system databases.

Answer 2

Hi @Rising Flight

Are there any steps which needs to be taken care on SQL before and after the upgrade

Before upgrading the database to a new version, you need to do some evaluation:

 SQL Server Upgrade Advisor is recommended. This tool is under the redist\Upgrade Advisor path. After successful installation, you can enter a Profiler Trace or SQL Batch file. Based on this information, the Upgrade Wizard evaluates whether upgrading an older version of SQL Server to a newer version of SQL Server application presents compatibility issues.

 Do a performance test on the new version of the database server

 Make a backup of the system and all databases before upgrading. This allows you to resume normal operations by reinstalling the old version of the database service even if the upgrade fails.

 For complex environments with database mirroring, replication, log shipping, clustering, etc., pay attention to the steps of upgrades.

After the database upgrade is successful, also need to:

 Verify that the compatibility level of the database is upgraded to the latest database version.

 Rebuild indexes on the database.

 Re-update statistics on the database.

Best regards,

Cosmog Hong