Hi to all:
The Log reader of my Transactional replication with no updates is giving me problems. The first error was that is couldn't execute the sp sp_replcmds, so I increase the query timeout property of the replication agent and decrease the ReadBatchSize property too. But now, if I put the ReadBatchSize to 10 (a very, very low value), after a while it show the message "The process is running and is waiting for a response from one of the backend connections." What I think that is looked somehow. If I rtun the agent with a lower value for the ReadBatchSize( for example 1), the log reader process only 1 transaction every time it runs.
What I think is that the log has one transaction to be replicated with some kind of problem and the log reader when it gets to that transactions, fails.
I know that I cant skip a transaction from the log to be replicated but that is not advisable. Any other ideas?