InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 16:08:48 GMT20http://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxi have T-replication, I usually stops the log reader agent from the publisher and synchronization status from subscriber and start them whenever needed.Tue, 07 Oct 2008 11:00:02 GMTALIF-662928http://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxDisable all the replication related jobs on publisher, distributor, subscriber then enable when you want to it. Hope it will work.Tue, 07 Oct 2008 06:30:48 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxmaybe 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 charmCheers RenatoTue, 07 Oct 2008 06:13:27 GMTRenato Marchesanihttp://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxAs 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 .Tue, 07 Oct 2008 01:39:34 GMTsandhyarao49http://www.sqlservercentral.com/Forums/Topic580818-291-1.aspx[quote][b]sandhyarao49 (10/5/2008)[/b][hr]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[/quote]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 replicationMon, 06 Oct 2008 18:35:57 GMTAdrian Robertsonhttp://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxIf 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.Mon, 06 Oct 2008 09:09:13 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxhi,I don't want to remove the replication permanently.For temporary purpose (just for 2-3 days)and again how to start the replicationThanks,sandhyaMon, 06 Oct 2008 08:56:07 GMTsandhyarao49http://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxhello,if you want to permanently remove replication, just delete the subscription (and/or the publication).Mon, 06 Oct 2008 01:11:19 GMTboglawhttp://www.sqlservercentral.com/Forums/Topic580818-291-1.aspxHI to all,I have a small doubt.1. how to stop the replication.(Is it disconnecting the publisher from the distributor or what)Thanks,sandhyaSun, 05 Oct 2008 02:44:22 GMTsandhyarao49