sql server replication: Replecation error -- sql server replication

Replecation error

<msnews.microsoft.com>
5/30/2007 2:30:39 PM

sql server replication:

Please help, I am getting the followng Error on my Server

[5/30/2007 2:28:16 PM]STGITDSQL.ITD: select @@SERVERNAME
[5/30/2007 2:28:16 PM]STGITDSQL.ITD: sp_MSgetversion
Status: 4096, code: 20024, text: 'Initializing'.
The agent is running. Use Replication Monitor to view the details of this
agent session.
Publisher: {call sp_repldone ( 0x00000000000000000000,
0x00000000000000000000, 0, 0)}
Status: 2, code: 0, text: 'The process could not execute
'sp_repldone/sp_replcounters' on 'STGITDSQL'.'.
The process could not execute 'sp_repldone/sp_replcounters' on 'STGITDSQL'.
Status: 2, code: 18752, text: 'Another log reader is replicating the
database.'.
Status: 0, code: 22017, text: 'The process could not set the last
distributed transaction.'.
Disconnecting from Publisher 'STGITDSQL'
The agent failed with a 'Retry' status. Try to run the agent at a later
time.

Re: Replecation error

Hilary Cotter
5/30/2007 10:22:29 PM

I just encountered this myself. I had to kill all the logreader agents in
task manager and then start them up one by one.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]