Publisher Issue

Avyayah 1,291 Reputation points
2023-07-25T22:27:59.0033333+00:00

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'

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,434 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-07-26T05:25:22.5133333+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.