Home Forums SQL Server 2008 SQL Server 2008 - General Stop and start Replication in SQL 2008r2 with the job agents, does it loose transactions? RE: Stop and start Replication in SQL 2008r2 with the job agents, does it loose transactions?

  • If you are looking to pause the flow of transactions from the distributor to the subscriber, then yes, all you would need to do is stop the subscriber job (distribution job or Synchronization job). The transactions will happily queue up in the distribution database for a default period of 72 hours. Once you restart the distribution job, the subscriber will catch up. it may not be entirely instant, if you have a large number of transactions to catch up on. Also, you should make sure the distribution database has room to grow, in case it needs to. I will bet that over the course of an hour it will not, but you should make sure.