November 18, 2003 at 1:54 am
We seem to have transactions traped in the log reader/whereever how can we tell sql to apply these transactions please help am at wits end.
November 26, 2003 at 7:43 am
First run the log reader agent with the logread.exe from the command line, with parameter OutPutVerboseLevel equal to 2 to find out what is really happening. then post the error here so we can help better.
You should also check for the sp sp_repldone in bol to see if it can help, but you should be carefull.
November 28, 2003 at 5:58 am
Totally agree. One case where things appear to be trapped is if you have a very long transaction. The log reader has to process every line even if it will never pertain to replication (index rebuid) and its quite possible for it to timeout before it hits the end of the transaction. One possibility anyway.
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply