Log Reader 2

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  September 15, 2004 at 2:59 am

  #102204

  Hi Guys,

  OK here is what I have.

  Within the Log Reader Agent Error details

  I have the following:

  Category Datasorce 18752

  Another log reader is replicating the database.

  Category Agent 22017

  The process could not set the last distributed transaction.

  And the log reader is showing:

  The process could not execute 'sp_repldone/sp_replcounters'

  Any ideas on how I can resolve this?  I have read that the Query Timeout parameter should be increased!!! Tried that...no effect.

  Regards..Graeme

• September 20, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  September 23, 2004 at 6:35 am

  #524142

  Check that there isn't anothuer log reader running in the server. Maybe someone started from the command line.

  Run sp_who2 to check the process and kill it, and then start the log reader job from SQL Server.