February 3, 2003 at 1:23 pm
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?
February 4, 2003 at 6:26 am
I already fixed it. I decrease to one the ReadBatchSize parameter of the log reader agent profile. Left the log reader reading all night from the log all the transactions needed for replication and When I returned today, I could Increase the value to it's original state of 500.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply