Hi All,
I have a bi-directional transactional replication between two SQL Server
2000 box. After I reboot the publisher, the Queue Reader kept failing, saying
"Queue Reader Aborting, the step failed, error 14151, state 1". And the worse
thing was that I could not restart it. It would fail immediately after I
restarted it. Any thought?
Thanks in advance,
Hi Franky,
It sounds like SQL Server Agent couldn't start the queue reader job. Could
you also check the job history at Management\SQL Server Agent\jobs\Queue
Reader job\View job history ro see if there is any information there?
Jing Sun
Microsoft SQL server Replication team
"Franky" <Franky@.discussions.microsoft.com> wrote in message
news:C9E1AB14-52EA-4B90-950F-5D2844BDBFC3@.microsoft.com...
> Hi All,
> I have a bi-directional transactional replication between two SQL Server
> 2000 box. After I reboot the publisher, the Queue Reader kept failing,
> saying
> "Queue Reader Aborting, the step failed, error 14151, state 1". And the
> worse
> thing was that I could not restart it. It would fail immediately after I
> restarted it. Any thought?
> Thanks in advance,
Monday, February 20, 2012
Queue Reader Aborting. The step failed
Labels:
aborting,
bi-directional,
box,
database,
failed,
failing,
kept,
microsoft,
mysql,
oracle,
publisher,
queue,
reboot,
replication,
server,
server2000,
sql,
step,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment