Sample Header Ad - 728x90

Do Basic Availability Groups have any benefits not found with Database Mirroring?

2 votes
1 answer
184 views
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.
Asked by J. Mini (1237 rep)
Jan 25, 2025, 08:37 PM
Last activity: Feb 3, 2025, 08:44 PM