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--
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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--