Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

replication Expand / Collapse
Author
Message
Posted Sunday, October 05, 2008 2:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, October 06, 2008 1:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, October 06, 2008 8:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, October 06, 2008 9:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
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
Posted Monday, October 06, 2008 6:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, October 07, 2008 1:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, October 07, 2008 6:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 6:27 AM
Points: 3, Visits: 49
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
Posted Tuesday, October 07, 2008 6:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 02, 2014 12:02 AM
Points: 185, Visits: 726
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
Posted Tuesday, October 07, 2008 11:00 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 31, 2014 10:49 AM
Points: 759, Visits: 637
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 »

Add to briefcase

Permissions Expand / Collapse