SQL Server-Delete replication

1.删除replication,先删除replication的作业,再删除对应的订阅,再删除发布;

2.相关脚本:删除监视器里不存在的条目sp_removedistpublisherdbreplication  @publisher =  'publisher server'    ,  @publisher_db =  'publisherDB'

go

3.删除DB在LOG Reader Agent中的发布 .delete from distribution.DBO.MSlogreader_agents where publisher_db ='PublisherDB'

原文地址:https://www.cnblogs.com/roseHLF/p/replicationRemoving.html