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.