Replication-删除发布备注

时间:2021-12-17 03:31:11

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'