Inplace upgrade of Server OS on a SQL 2012 Database server

Jayanth Reddy, Sirigirireddy 1 Reputation point
2022-11-28T06:27:55.38+00:00

We have an SQL database server (version 2012) which is running on server OS 2012 R2. We want to upgrade the Server OS to 2019 and later upgrade SQL to version 2016.

Wanted to know whether it was safe to do an inplace upgrade of the server OS 2012R2 to Server OS 2019. Is this safe considering that the SQL application is running on it?

or is the best option be to install a separate new server with Server OS 2019 and then backup and restore the SQL catalogues to the new server.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,577 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2022-11-28T13:56:47.8+00:00

    Yes, the latter option is much safer. Clean install Server 2019, patch fully, then install SQL Server and do the restore.

    --please don't forget to upvote and Accept as answer if the reply is helpful--