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 for business | Windows Server | User experience | Other
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--


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.