Hi,
Our production site, I enabled snapshot replication, last night the
distribution agent failed with error message: Detect nonlogged agent
shutdown. I really don't know what that means; can someone help me to solve
this problem?
Regards,
-Chen
Sometimes the binary crashes and doesn't hand an error back to the SQL
Server subsystem.
In this case restart the distribution agent to see if it is a transitory
error.
You might also want to enable logging to see what it gives you - if
anything. Follow this link
http://support.microsoft.com/default...b;en-us;312292
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:26344E32-2FED-4A84-B73C-544ED47023BA@.microsoft.com...
> Hi,
> Our production site, I enabled snapshot replication, last night the
> distribution agent failed with error message: Detect nonlogged agent
> shutdown. I really don't know what that means; can someone help me to
solve
> this problem?
> Regards,
> -Chen
>
|||Thanks! I will try it.
"Hilary Cotter" wrote:
> Sometimes the binary crashes and doesn't hand an error back to the SQL
> Server subsystem.
> In this case restart the distribution agent to see if it is a transitory
> error.
> You might also want to enable logging to see what it gives you - if
> anything. Follow this link
> http://support.microsoft.com/default...b;en-us;312292
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:26344E32-2FED-4A84-B73C-544ED47023BA@.microsoft.com...
> solve
>
>
Friday, February 24, 2012
Distribution agent failed
Labels:
agent,
agentshutdown,
database,
detect,
distribution,
enabled,
error,
failed,
message,
microsoft,
mysql,
nonlogged,
oracle,
production,
replication,
server,
snapshot,
sql,
thedistribution
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment