Replication in SQL2000

  • I want to pause replication for an hour. By stopping the log reader agent and then restarting it after a hour. 1. Will it stop the replication or is there something else to do? 2. If so, will the replication carry on where it left off?

  • what kind of replication you are using? I have transactional replication here and normally stop the log & distributor agent both but for major break (longer duration) I simply disable & enable the replication itself.

    The best thing would be to ask this question at http://www.replicationanswers.com/Default.asp

    Alternatively, I can test this for you in the evening in the test environment and get back to you by tomorrow :hehe:

    Regards

    Chander

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply