The Log Reader Agent has failed again with the error "Could not execute
sp_repldone/sp_replcounters.." and we are unable to restart the agent.
MSrepl_transactions table holds two entries on the Distribution database one
dated 9-24 and the other 10-10, and the xact_id is not the same as the one
listed with sp_replcmds run on the publisher. What can we do to restart the
Log Agent and not loose any transactions?
Please help...
Thanks,
Fidel Arbizu.
enable logging as per this kb and post the log back here.
http://support.microsoft.com/default...b;en-us;312292
"farbizu" <farbizu@.discussions.microsoft.com> wrote in message
news:8903046C-0E27-4200-AED8-C411BDF18E34@.microsoft.com...
> The Log Reader Agent has failed again with the error "Could not execute
> sp_repldone/sp_replcounters.." and we are unable to restart the agent.
> MSrepl_transactions table holds two entries on the Distribution database
> one
> dated 9-24 and the other 10-10, and the xact_id is not the same as the one
> listed with sp_replcmds run on the publisher. What can we do to restart
> the
> Log Agent and not loose any transactions?
> Please help...
> Thanks,
> Fidel Arbizu.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment