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: 334
sql-server
|sql-server-2000
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