question

mimkod avatar image
mimkod asked

Best way to upgrade from 2012 R2 to 2019?

I have 3 SQL servers 2012R2 running in cluster and AlwaysOn.

I got 3 new physical servers and need to move all the databases to the new environment (which will be made on the 3 new servers) and upgrade to SQL server 2019.

Is it better to add the new servers to the existing cluster one by one and when it's synced I remove the old servers and then upgrade the cluster?

or should I take a Full backup from the old servers and restore to the new servers and then stop the services (Outage) and backup the transaction logs (delta) and then run the new servers?


Open to your suggestions and ideas.


Best regards.

sql-server-2012sql servermigrationupgrade plan
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.