replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » replication

replication

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Sunday, October 05, 2008 2:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

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

Post #580818

boglaw

Posted Monday, October 06, 2008 1:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 27, 2008 9:17 AM
Points: 2, Visits: 11

hello,

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

Post #580924

sandhyarao49

Posted Monday, October 06, 2008 8:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

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

Post #581132

steveb.

Posted Monday, October 06, 2008 9:09 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

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.

Post #581144

Adrian Robertson

Posted Monday, October 06, 2008 6:35 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, October 11, 2009 3:17 PM
Points: 23, Visits: 107

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

Post #581452

sandhyarao49

Posted Tuesday, October 07, 2008 1:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

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 .

Post #581565

Renato Marchesani

Posted Tuesday, October 07, 2008 6:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 13, 2012 9:46 AM
Points: 3, Visits: 26

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

Post #581719

Rajesh kasturi

Posted Tuesday, October 07, 2008 6:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:26 PM
Points: 185, Visits: 725

Disable all the replication related jobs on publisher, distributor, subscriber
then enable when you want to it.
Hope it will work.

Rajesh Kasturi

Post #581728

ALIF-662928

Posted Tuesday, October 07, 2008 11:00 AM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759, Visits: 613

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

Post #582004

« Prev Topic | Next Topic »

Permissions