Post reply

replication

  • October 5, 2008 at 2:44 am

    #193964

    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

  • October 6, 2008 at 1:11 am

    #880972

    hello,

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

  • October 6, 2008 at 8:56 am

    #881131

    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

  • October 6, 2008 at 9:09 am

    #881140

    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.

  • October 6, 2008 at 6:35 pm

    #881393

    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

  • October 7, 2008 at 1:39 am

    #881468

    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 .

  • October 7, 2008 at 6:13 am

    #881584

    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

  • October 7, 2008 at 6:30 am

    #881591

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

    then enable when you want to it.

    Hope it will work.

    Rajesh Kasturi

  • October 7, 2008 at 11:00 am

    #881823

    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