In this blog post, let’s learn about the error message “41140 – Availability group ‘%.*ls’ cannot process the ALTER AVAILABILITY GROUP command, because the local availability replica is not the primary replica. Connect to the server instance that is currently hosting the primary replica of this availability group, and rerun the command.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
41140 – Availability group ‘%.*ls’ cannot process the ALTER AVAILABILITY GROUP command, because the local availability replica is not the primary replica. Connect to the server instance that is currently hosting the primary replica of this availability group, and rerun the command.
Reason for the Error
To be update soon…
Solution
To be update soon…