Replication: Logreader agent failing for some databases.

• Surii

  Default port

  Points: 1497

  More actions

  September 19, 2011 at 1:02 pm

  #248156

  Hello All,

  we have peer to peer replication configured with a dedicated distributor. Logreader agent runs on the distributor, and the job is failing at times for some databases with a message: The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more information.

  I don't see much information about the exact error in replication monitor and job history. Where can i find more information about this issues, any suggestions are really appreciated.

  Thanks,

  Suri.

• Chuck Hottle

  SSCarpal Tunnel

  Points: 4777

  More actions

  September 19, 2011 at 2:02 pm

  #1383475

  It might help to enable additional logging so you might get more information. Take a look at this,

  http://support.microsoft.com/kb/312292