Query on SQL services

Rising Flight 4,516 Reputation points
2023-09-28T05:05:52.47+00:00

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.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,744 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,788 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,588 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
0 comments
Accepted answer
  1. Olaf Helper 44,501 Reputation points
    2023-09-28T05:16:15.68+00:00

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

    https://video2.skills-academy.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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 27,016 Reputation points
    2023-09-29T06:34:47.7433333+00:00

    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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.