Sql server 2000 replication error

Posted by Renato on Server Fault See other posts from Server Fault or by Renato
Published on 2010-02-01T16:00:09Z Indexed on 2010/04/04 8:13 UTC
Read the original article Hit count: 319

Filed under:
|

Good morning,

I have a sql server 2000 machine, with SP4.

I have a transactional replication.

A keep receving this error message:

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

the logreader stops responding.When i click start it starts fine, and the replication starts fine.And then, works for hours, and the problem comes back.

In the begining i though it could be timeouts, but i already set a couple of parameters in the logreader profile,like querytimeout/readbatchsize.

Sometimes when the logreader stops,it generates a dump, but not always.

In event viewer, it appears this message:

17066 : SQL Server Assertion: File: , line=1985 Failed Assertion = 'startLSN >= m_curLSN'.

18052 : Error: 3624, Severity: 20, State: 1.

17066 : SQL Server Assertion: File: , line=2223 Failed Assertion = 'm_noOfScAlloc == 0'.

I also executed checkdb in the databases, and they are fine.

have you every experienced something similar?

thanks in advance,

Renato Alves.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2000