some questions on upgrading Windows 2012r2 with SQL Standard 2014

Takami Chiro 231 Reputation points
2023-07-18T22:29:16.0766667+00:00

HI everyone,

Good afternoon. Hope you all doing well.

I have an old VM in Hyper-V environment. It is running in Windows2012r2 with SQL 2014 standard version. I would like to upgrade the server.

1.) Can I upgrade 2012r2 directly to 2019? In MS, it suggests running the upgrade to 2016 first and then 2019. However, I saw some youtube videos saying it can be done directly from 2012r2 to 2019.

2.) Should I upgrade the SQL from 2014 to 2019 first before the OS upgrade? Or it does not matter?

3.) The size of the VM is 1TB, and there is only 300gb left on the Hyper-V host. Do you think if that will be enough for me to take a snapshot?

Thank you for your help!

Takami Chiro

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,301 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,737 questions
{count} votes

Accepted answer
  1. Limitless Technology 44,006 Reputation points
    2023-07-19T12:26:45.38+00:00

    Hello there,

    The recommended upgrade path, according to Microsoft's documentation, was to upgrade from Windows Server 2012 R2 to Windows Server 2016 first and then to Windows Server 2019.

    However, it's worth noting that Microsoft might have introduced new updates or supported direct upgrade paths between versions after my last update. To ensure that you have the most accurate and up-to-date information, I recommend checking Microsoft's official documentation or support resources for the latest information on supported upgrade paths.

    Always perform a full backup of your system before attempting any major upgrade to safeguard your data and ensure you have a recovery option in case anything goes wrong during the upgrade process.

    I used AI provided by ChatGPT to formulate part of this response. I have verified that the information is accurate before sharing it with you.

    Hope this resolves your Query !!

    --If the reply is helpful, please Upvote and Accept it as an answer--

    1 person found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 99,296 Reputation points MVP
    2023-07-19T09:43:42.42+00:00

    First, clone the VM and test the upgrade on the clone.

    Yes, doing the OS upgrade before the SQL Server upgrade would be the only option. I don't think it is supported running SQL 2014 on server 2019, but I would expect it to run anyway.

    And, again, clone the VM to run a test.

    1 person found this answer helpful.
    0 comments No comments

  2. Takami Chiro 231 Reputation points
    2023-07-19T15:16:01.98+00:00

    I just saw the matrix and SQL 2019 cannot run in 2012r2. So Can I keep SQL 2014 and upgrade the OS from 2012r2 to 2019. After this is one, I can upgrade the SQL from 2014 to 2019?

    0 comments No comments

  3. Takami Chiro 231 Reputation points
    2023-07-19T15:17:24.0666667+00:00

    I found this in Microsoft. The 2012r2 can be upgraded to 2019 directly based on the article. Thank you very much for all your help!

    https://learn.microsoft.com/en-us/windows-server/get-started/upgrade-overview