Skip to content

How to Remove Replication Monitor Red Crosses

Provided that there are NO other publications against that database, the sp_removedbreplication can be used to remove all replication objects from the database in which it is executed, however it does not remove objects from the distribution database:

If sp_removedbreplication won’t work for you I recommend creating another publication with the exact name of the previous one you deleted. Then, remove the newly created publication following instructions here:

Failing that, it is possible to manually inspect and remove these from the distribution database itself;

select * From distribution.dbo.MSpublications
select * from distribution.dbo.MSReplication_Monitordata
select * from distribution.dbo.MSsubscriptions
select * from distribution.dbo.MSdistribution_agents
select * from distribution.dbo.MSpublication_access
select * from distribution.dbo.MSpublisher_databases 
select * from distribution.dbo.MSrepl_originators
select * from distribution.dbo.MSsnapshot_agents
select * from distribution.dbo.MSsnapshot_history 
select * from distribution.dbo.MSsubscriber_info 
select * from distribution.dbo.MSsubscriber_schedule
select * from distribution.dbo.MSmerge_agents
select * from distribution.dbo.MSmerge_articlehistory
select * from distribution.dbo.MSmerge_history
select * from distribution.dbo.MSmerge_identity_range_allocations
select * from distribution.dbo.MSmerge_sessions
select * from distribution.dbo.MSmerge_subscriptions

Important; Make sure that the Replication Monitor is NOT running while performing the above checks and deletions, as this will automatically recreate the entries in the tables!

Hope this helps!