In this blog post, let’s learn about the error message “47108 – The %ls operation is not allowed by the current availability group configuration. The availability group ‘%.*ls’ only supports two synchronous mode replicas and required_syncrhonized_secondaries_to_commit is zero when configuration-only mode replica is specified. Verify that the specified availability group availability mode is correct, then retry the operation.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
47108 – The %ls operation is not allowed by the current availability group configuration. The availability group ‘%.*ls’ only supports two synchronous mode replicas and required_syncrhonized_secondaries_to_commit is zero when configuration-only mode replica is specified. Verify that the specified availability group availability mode is correct, then retry the operation.
Reason for the Error
To be update soon…
Solution
To be update soon…