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

Viewing 1 post (of 1 total)
  • Author
    Posts

  • BumbleBee
    Member
    #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

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Register for Advanced Microsoft 365 Day!

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.

RSVP Now

Sponsored By