Saturday, February 25, 2012

Queue Reader failed for Transactional Repl

Hello,
I have set up queued updating Transactional Repl. The Queue Reader keeps
failing and cannot start up any more. The output shows the following error
"cannot have more than one instance of queue reader agent for the
distribution database". What does this error message mean? Please help.
Thanks in advances
Please can you post up the complete error message, including the error
number?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
Thanks for your reply. Finally I solved by shutting down the queue reader
exe on the task manager. I thought the exe would not run if the Queue Reader
fails. But it is cluster environment and it might be a bug somewhere with the
Queue Reader exe. After I shut down the process, restarting Queue Reader
agent worked fine.
have a good one,
FJY
"Paul Ibison" wrote:

> Please can you post up the complete error message, including the error
> number?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

No comments:

Post a Comment