Replication Issue

• Rajarajan-131202

  Grasshopper

  Points: 19

  More actions

  January 16, 2007 at 7:18 pm

  #98031

  Hi,

  I am gettting  an error message

  The process could not execute 'sp_replcmds' on 'servername'.

  Timeout expired

  (Source: ODBC SQL Server Driver (ODBC); Error number: 0)

   on one of my SQL server (MS SQL server 2000 + SP3) and i have restarted the logreader agent and it retrying for 10 times again failing with same error.

  Please some one help me to fix the issues.

  Thanks

  Rajarajan 

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 4:48 pm

  #684151

  PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication

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

  You can also log the error message for troubleshooting...

  How to enable replication agents for logging to output files in SQL Server

  http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&Product=sql2k

  MohammedU
  Microsoft SQL Server MVP