none
Replication agent stopped automatically

    Question

  • Replication agent automatically stopped. (Not failed). Then we restarted by Right Click --> Start Synchronizing

    Why it hppens? What could be the reason. We didn't find any error.

    This is SQL Server 2008 R2.

    Thursday, October 12, 2017 10:22 PM

Answers

  • Make sure the job owner is sa and if that does not allow the job to start successful copy out the run agent command and run it from the command like. You will need to run it in

    c:\Program Files\Microsoft SQL Server\XXX\com

    replacing xxx with your version number.

    Friday, October 13, 2017 2:23 AM
    Moderator

All replies

  • Check the run agent job step to ensure that it has the -Continuous parameter in place.
    Thursday, October 12, 2017 11:31 PM
    Moderator
  • Yes. The parameter already there
    Friday, October 13, 2017 2:13 AM
  • Make sure the job owner is sa and if that does not allow the job to start successful copy out the run agent command and run it from the command like. You will need to run it in

    c:\Program Files\Microsoft SQL Server\XXX\com

    replacing xxx with your version number.

    Friday, October 13, 2017 2:23 AM
    Moderator