question

rehaan avatar image
rehaan asked

Transactional Replication failing

Hi Team,


I have transaction replication set up between SQL16 and SQL19. I have set up transactional replication - initialization using backup as my DB is huge in size. Once the subscription is created I started to see this error continuously. It doesn't say an invalid object, or row not present at the subscriber, or any constraint errors. Please can anyone help? I have read 100's of articles on the net, but couldn't find any solution so far.


I did the same for a database that is small in size and it has no issues, so I don't think it is an issue due to different versions of SQL




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 Distributor are still active.

Error executing a batch of commands. Retrying individual commands.



1632588022832.png

mssqlsql-server-2016transactional-replication
1632588022832.png (98.8 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

Do you have heavy load at the subscriber?

Remove the -SubscriptionStreams option if you have added it to the agent and enable RCSI on teh subscription database to reduce blocking the distribution agent

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.