Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    CA, USA
    Posts
    21

    Unhappy Unanswered: Queue Reader agent fails to start when stopped through Enterprise Menager

    I've set up transactional replication with queued updating. If I stop the queue reader agent through EM, I can't start it again. Agent's history says "Queue Reader aborting. The step failed."

    All servers are SQL Server 2000 SP3.

    Help is greatly appreciated!

  2. #2
    Join Date
    Jun 2003
    Location
    CA, USA
    Posts
    21

    Solved it!!!!

    OK, I found what my problem was (actually not really mine - it's all EM's fault). When you stop the Queue Reader agent through EM, in reality that process is not stoped, but continues to run on the machine. However, the EM doesn't see it and when you try to start it again, of course , it doesn't want to start another instance of Queue Reader agent.

    Basically, I had to go and manually stop the process, and only then start it again through EM.

    Bad, bad Enterprise Manager!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •