MSSQLSERVER_47521

Applies to: Azure SQL Managed Instance

Details

Attribute Value
Product Name SQL Server
Event ID 42109
Event Source MSSQLSERVER
Component SQLEngine
Message Text Secondary replica could not be built as the replica request was not received from the primary, or not processed correctly. Check the state of the primary server and ensure that Availability Group on this server is not empty, and that it contains healthy databases.

Explanation

The link couldn't be established because the replica request wasn't received from the primary, or it wasn't processed correctly.

This could be due to the following reasons:

  • Connection to the primary replica failed.
  • The availability group is empty.
  • The database in the availability group isn't healthy.

User Action

Check the state of the primary server and ensure the availability group isn't empty, and that it contains healthy databases. Check network connectivity. Retry the operation after the primary server has been verified successfully.