replication

  • HI to all,

    I have a small doubt.

    1. how to stop the replication.

    (Is it disconnecting the publisher from the distributor or what)

    Thanks,

    sandhya

  • hello,

    if you want to permanently remove replication, just delete the subscription (and/or the publication).

  • hi,

    I don't want to remove the replication permanently.

    For temporary purpose (just for 2-3 days)

    and again how to start the replication

    Thanks,

    sandhya

  • If you want to remove individual objects from replication then you can uncehck them in the articles tab of the publication properties.

    But as the other poster said it is probably easier to drop the subscription and then re-add it once you are ready to start replication again.

  • sandhyarao49 (10/5/2008)


    HI to all,

    I have a small doubt.

    1. how to stop the replication.

    (Is it disconnecting the publisher from the distributor or what)

    Thanks,

    sandhya

    There's a big difference between pausing the replication (no db changes, just stopping the synch jobs from occurring) and removing the replication completely (no more RowGUID field on the replicated tables, essentially deleting all information pertaining to the replication setup)

    What is it you're trying to achieve by stopping replication? Knowing this might answer whether you simply need to disable the synch jobs, or remove replication

  • As per the down stream requirements we need to stop the repliaction and let their job to run.

    After completing their job we have to start the replication.

    Kindly suggest on this .

  • maybe it would be better to script all replications, drop them and then re-run the scripts. But I cannot say it this is the best solution for your environment. In my case it worked like a charm

    Cheers

    Renato

  • Disable all the replication related jobs on publisher, distributor, subscriber

    then enable when you want to it.

    Hope it will work.

    Rajesh Kasturi

  • i have T-replication, I usually stops the log reader agent from the publisher and synchronization status from subscriber and start them whenever needed.

Viewing 9 posts - 1 through 8 (of 8 total)

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