Publisher Issue

Question

The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Di

Publisher is setup in a server and Distributer is setup in another server. Publisher will replicate data to Distributer.

Ran this on the distributor and it is active now.

exec sp_changedistpublisher @publisher = 'US51DBS01', @property = 'active', @value = 'true'

Answer 1

Hi @Avyayah

According to your error message, I found this official document, hoping to help you troubleshoot: https://learn.microsoft.com/en-us/sql/relational-databases/replication/mssql-eng020554?view=sql-server-ver16.

Best regards,

Aniya