2

Assuming SQL Server 2022 Standard Edition on Windows, I simply cannot see any benefits to using Basic Availability Groups instead of Database Mirroring. Is there anything offered by Basic Availability Groups but not Database Mirroring?

In both cases:

  • You can only have 1 primary and 1 secondary
  • The secondary is not readable
  • Databases cannot be grouped in any way allowing them to fail over together
  • Replication can either be sync or async
  • Automatic page repair is enabled.

The only differences that I've found between the two features are that Basic Availability Groups cannot be upgraded to Enterprise Edition and that Database Mirroring is officially deprecated.

I appreciate that Basic Availability Groups are harder to set up than mirrors, but I am only asking about benefits of Basic Availability Groups over Database Mirroring.

J. Mini
  • 1,161
  • 8
  • 32

1 Answers1

7

Replication can either be sync or async

In Standard Edition, mirroring is only allowed in synchronous commit mode.

Another benefit is the listener does not require changing the client connection string.

Paul White
  • 94,921
  • 30
  • 437
  • 687
SergeyA
  • 1,522
  • 1
  • 5
  • 9