Saturday, February 19, 2011

How do you remove obsolete publications in the Replication Monitor?

Through some bungling in creating and removing publications, I was left with a lot of obsolete publications which for some reason still remains in the Replication Monitor.

How do you remove these publications? It doesn't seem to have a clear way to remove them.

From stackoverflow
  • This is an old question of mine, but then again at least I found a way to resolve it.

    I was able to remove the publications is by creating a new publication with the same name, then delete the publication again. This time the publication will no longer appear in the Replication Monitor. I did not remember if the publication has to be the same type as the obsoleted one, but it works.

    UPDATE: Okay, the publication type and database name is important, otherwise the newly created publication will be considered as a different publication. Kinda obvious, but now I'm sure of it.

0 comments:

Post a Comment