Share via

Order of upgrading OS & SQL Server

Anonymous
2024-06-10T07:13:26+00:00

Is the following order fine for us to proceed with?

Back Up of both WS & SQL DBs

  1. Upgrade SQL 2014 Enterprise RTM to SQL 2014 SP3 Enterprise
  2. Upgrade WS 2012 R2 to WS 2019 DC
  3. Upgrade Roles & File server, SCCM
  4. Upgrade SQL 2014 Enterprise SP3 to SQL 2022 Enterprise as per here.
  5. Upgrade WS 2019 DC to WS 2022 DC
  6. Upgrade Roles & File server, SCCM

BTW, SSMS & SSDT - can it be a direct install of latest versions of them?

Are there anything else that we need to pay attention to?

Windows for business | Windows Server | Devices and deployment | Set up upgrades and drivers

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-06-11T14:18:40+00:00

Hello Radhai,

thank you for posting on the Microsoft Community Forums.

Based on the description, I understand that your issue is related to SCCM and SQL Server.

Since there are no engineers dedicated to SCCM and SQL Server in this forum. In order to be able to deal with your questions quickly and efficiently, I recommend that you repost your questions in the Q&A forum, where there will be a dedicated engineer to provide you with a professional and effective response.

Here is a link to the Q&A forum: https://learn.microsoft.com/en-us/answers/questions/

Have a nice day.

Best regards,

Lei

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-06-12T04:27:22+00:00

    Fine Lei, Thank you!

    Was this answer helpful?

    0 comments