SQL Server Error Msg 19511 – Cannot join distributed availability group ‘%.*ls’. The local availability group ‘%.*ls’ contains one or more databases. Remove all the databases or create an empty availability group to join a distributed availability group.

In this blog post, let’s learn about the error message “19511 – Cannot join distributed availability group ‘%.*ls’. The local availability group ‘%.*ls’ contains one or more databases. Remove all the databases or create an empty availability group to join a distributed availability group.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

19511 – Cannot join distributed availability group ‘%.*ls’. The local availability group ‘%.*ls’ contains one or more databases. Remove all the databases or create an empty availability group to join a distributed availability group.

Reason for the Error

To be update soon…

Solution

To be update soon…