SQL Server Performance

--SQL Agent--

Discussion in 'Getting Started' started by lara99, Feb 15, 2008.

  1. lara99 New Member

    I got two simple question about the replication
    1. If a server is replicating some databases to other server. Will restarting the agent on any othe ther servers either publisher or subscriber would effect the replication.
    2.If I restart my server, would replication be effected.
    Thank You,
  2. happycat59 New Member

    Replication is designed to handle these events (and many others). Replication will simply continue from where it got to before the agent was stopped or the server restarted. If replication is part of the way through a transaction, the transaction is rolled back and will be re-run when the sql agent is restarted.

Share This Page