Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET! Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET!

Moving from SQL 2008R2 to SQL 2019

This topic has 1 reply, 2 voices, and was last updated 1 year, 4 months ago by Ossian.

Viewing 1 post (of 1 total)

Author

Posts
BumbleBee
Member

Mar 09, 2020 at 5:56 am #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

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

GET-IT: Advanced Microsoft 365 1-Day Virtual Conference - Live August 24th!

Join us on Tuesday, August 24th and hear from Microsoft MVPs and industry experts about how to take advantage of Microsoft 365 at a technical level and dive deep into the features and functionality that will make your environment more secure and compliant.

Sponsored By