Moving from SQL 2008R2 to SQL 2019

This topic contains 1 reply, has 2 voices, and was last updated by Avatar Ossian 3 weeks, 4 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Avatar
    BumbleBee
    Participant
    #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

    Avatar
    Ossian
    Moderator
    #626669

    Always On Availability Groups are fully supported (like all the other good features) in the Enterprise Edition of SQL Server
    For the Standard Edition, there are Basic Availability Groups https://docs.microsoft.com/en-gb/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver15 which are very like mirrored servers

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.