Stop replication using scripts

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Stop replication using scripts

Author

Topic

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-11-04 : 03:49:51

Hello All
Can i use the stored procedure sp_droppublication to stop the ongoing replication.?
If yes, can i use it from a remote machine to turn off the replication ??

Regards
Srivatsa

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2009-11-04 : 06:24:54

for dropping replication, generate SQL replication script using "To drop or disable the componenets" option & use accordingly. You should drop the subscription before removing the publication. The steps for merge for instance should be

-- Dropping the merge subscriptions
exec sp_dropmergesubscription
-- Dropping the merge articles
exec sp_dropmergearticle
-- Dropping the merge publication
exec sp_dropmergepublication

Thanks,
Krishna
www.SQLServer.in

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-11-04 : 10:46:12

Can i use the following scripts from a remote machine ??

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2009-11-05 : 05:05:08

don't do it from local system, could do from a remote server by adding the source server to object explorer. I normally do it from a publisher or subscriber machine.

Thanks,
Krishna
www.SQLServer.in

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources