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'