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'

posted @ 2017-06-14 16:45  rosewong  阅读(391)  评论(0编辑  收藏  举报