Let me preface this in that I'm working as an accidental DBA at the moment.
We have continuous transactional replication running. For some reason the Distribution Agent stops with a message of "success", but I can't understand at all why it is stopping and from the logs I don't get much information.
Other than looking at the monitor does anyone have some good ideas as to where I can get a bit more detail? I can do verbose logging to a file but the replication has lots of data and the files grow really big really fast.
Is there a way to have the Distribution Agent restart itself whenever it stops other than when I manually stop it? Maybe adding an additional step to the Agent job?