Score:0

Considerations for Server OS Upgrade (Win2012R2 to 2019) hosting SQL Server?

cn flag

I am not a DBA so I am not well versed on the intricacies, considerations, potential issues with in-place upgrading just the OS of an existing SQL Server.

A client has several stand-alone SQL Server 2012 servers on Windows Server 2012 R2. Their current mandate is to upgrade their server OSes to Windows 2016 or 2019.

In place upgrades of the OS is straight forward enough but are there any special considerations when upgrading the underlying OS on SQL Servers (and related services: reporting, analysis, integration) that I should keep in mind?

Thanks in advance

Score:1
za flag

I did this nearly a year ago, the only thing I did, was first to create a Backup then update the SQL to the latest and installed any versions between 2012 and 2019, some Windows updates may be required to upgrade to the next, but it was running Smoothly and fine.

REMIND Backing up!! (Shutdown and take there, no online snapshot due to the Consistency)

Work steps

  • update the SQL Server
  • Stop & Shutdown SQL Service.
  • in place upgrade to 2016 + all Windows updates
  • in place upgrade to 2019 + all Windows updates

For All Action should be planned from starting till end depending on size Around 1-2Days. (In my Action it was required 3 days from first to last step)

The Server is now working since then without any error.

It is Possible, but official supported, to upgrade from 2012 to R2 and start forward to the in place upgrades till 2019.

Conclusion

Remind, that, in case if it's a VM, it's mostly better to back up the Databases and replace the VM with the newest OS and SQL if possible via a Fresh Installation. Mostly it takes less time.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.