No Publication – but still shows up in Replication Monitor!!!

Issue: Replication has been removed from a SQL Server cleanly, yet the replication monitor still shows the publication

select * from distribution..MSReplication_Monitordata

The rogue publication should show up in the list from the query above. Why not just delete the row relating to the rogue publication – you can try but it wont delete.

delete from distribution..MSReplication_Monitordata
where publisher_db = 'FutureProofStage'

(1 row affected)

However, when you check the table again, the row will still be there.

Even if it doesn’t show up the query, the steps below should help fix it.

Not really sure why it happens… but read the following post on how to fix it – http://www.sqlservercentral.com/Forums/Topic125951-7-2.aspx

In Summary, you need to create the publication again with the same publication name and against the same publication DB and then remove it.
It has to do with some sort of incomplete cleanup. The publication only needs to have one article.

After  completing these steps, the row will be removed from distribution..MSReplication_Monitordata

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: