SQL 2008 Log Reader fails with 'Could not execute sp_replcmds" - Transactional Replication

Posted by JoeJoe on Server Fault See other posts from Server Fault or by JoeJoe
Published on 2010-06-17T00:08:54Z Indexed on 2010/06/17 0:13 UTC
Read the original article Hit count: 709

Transactional Replication. Two servers SQL server 2008sp1 using domain account. If I make a small dummy setup it works fine. If I use copy of my Production database it fails with MSSQL_REPL20011 error 'could not execute sp_replcmds'.(and MSSQL error 15517, and MSSQL_REPL22037). I've restarted the Agent - no good. How do I troubleshoot this to find root cause?

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about replication