Availability group fail-over
Forced manual fail-over with data loss (2 step) To force failover with data loss, connect to the SQL Server instance that hosts the target secondary replica and then run the following command: When the previous primary replica recovers, it will also assume the primary role. To ensure that the previous primary replica transitions into a …
