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?

  • Pablo Campanini-336244 (1/21/2014)


    1.- Do I need to stop only the subscription job?

    That's the easiest way. If you were to stop the log reader it would have the same effect but would potentially mean the transaction log would grow.

    Pablo Campanini-336244 (1/21/2014)


    2.- If I start that job again(Subscription) after 1 hour, does it loose transactions?.

    No. All transactions marked for replication would be read and commited to the distribution database by the logreader

    Pablo Campanini-336244 (1/21/2014)


    3.- Do I need to run the snapshot agent everytime I stop/start the subscription job?

    No. For the very reasons above (the distribution db exists for a reason!). If that was a requirement it would be unmanageable and mean every bit of maintenance would require re-initialisation.

    Is there a reason why you need to stop replication? It could be more beneficial to leave it on if its for data changes.