Saturday, February 25, 2012

Queue reader Agents Failed - SQL 200 replication

Guys,

I get the error message: Queue reader aborting. The steps failed...in queue reader agents of SQL 2000 replication. Could any one give me a hint of how to troubleshoot this problem? Thanks a lot in advance.

Are there any other messages in the history tables? If not, can you modify the queue reader profile by increasing the outputverboselevel and directing the output to a file? Add the following:

-OutputVerboseLevel 2 -Output "c:\somefolder\output.txt"

This will direct the queue agent output to an arbitrary file. It might have more detail with regards to the error being raised.

No comments:

Post a Comment