You are here: Re: SQL 2005 error: Replication-Replication Distribution Subsystem: agent (null) failed. « MsSQL Server « IT news, forums, messages
Re: SQL 2005 error: Replication-Replication Distribution Subsystem: agent (null) failed.

Posted by bourgon on 07/02/07 15:46

On Jun 18, 1:06 pm, "jeff_y" <jeffrey...@abc.com> wrote:
> I get the similar error message, can this be explained in terms of its
> possible causes?
> My observation is my transactional replication goes well without any
> problems, but I keep on finding this annoying error in the sql server log.
> Any thoughts on this issue is highly appreciated.

Jeff, we wound up contacting Microsoft about it. They had us run a
trace on the server (turning on the "errors and warnings"), determined
that it had something to do with subscriptions to a particular
published database, then we removed and recreated them.

We also, once we'd scripted and removed the subscriptions, we ran
sp_removedbreplication. Hope this helps.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация