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 5, 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 6, 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 6, 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 6, 2008 9:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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 6, 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 7, 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 7, 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 7, 2008 6:30 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, January 2, 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 7, 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: Wednesday, July 9, 2014 10:03 AM
Points: 759, Visits: 642
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