Moving from SQL 2008R2 to SQL 2019

Viewing 1 post (of 1 total)
  • Author

  • BumbleBee


    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?


Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Download this eBook!

External Sharing and Guest User Access in Microsoft 365 and Teams

his eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure. The eBook will also outline some of the major decision points across four general-purpose guest access policy scenarios for how an organization can set this up with standard licensing.

Download Now

Sponsored By