Friday, March 30, 2012

Problems with transactional replication.

Hi, I have confired some transactional replication with puss subscrition
between servers running sql server 2000 sp3. The replication works fine,
but yesterday after the publication/distribution was restared the log
reader agent of each publication reports this error:
The process could not execute 'sp_msadd_repl_commands27hp'
on publishername
Do somebody know how could I resolve the problem.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Please try increasing theLogReader's QueryTimeout parameter.
Also it might be interesting to check the view msdistribution_status to see
how many commands are in the pipeline.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

No comments:

Post a Comment