Moving from SQL 2008R2 to SQL 2019

[BumbleBee]

#626654

Hi,

I am about to move our DB from MSSQL 2008 R2 STD server to MSSQL 2019 server.
We have 2 DBs on the 2008 server with Log Shipping.

On the new 2019 SQL server, I would like to have “Mirror” configuration for both DBs, but if I understand correctly, there is no more “Mirror” as it has been deprecated.
The new technology, MS is using now is “always On”?

In order to have that “Allways On” configuration for both DBs on the same Instance, do I need the Ent ver or I can stay with the Std ver which held Mirror configuration for each DB in the same instance?

Thanks

[Author]

Posts