after the migration recheck the availability mode for the availability replica(s), the availability mode of the secondary replica can be changed back to synchronous commit.

Using the SSMS, navigate to the Availability Group menu, select Secondary replica(s) line and change both Availability Mode to synchronous-commit and Failover Mode to automatic:


check-circle-line exclamation-circle-line close-line
Scroll to top icon