Monday, February 20, 2012

Old Subscriptions?

Hello, I have a server that lists several Subscriptions (under Replication ->
Subscriptions in Enterprise Manager) that are no longer in use. Two of them
reference a server that was decomissioned over a year ago which no longer
exists.
Why do these old subscriptions still show up in the Subscriptions list? Is
there a way to remove them? If so, how?
I would appreciate any feedback...
Thanks,
John
You can have a look at sp_MSenumsubscriptions to see what is happening when
you click on the subscriptions folder. The key tables in each subscribing
databases are sysmergesubscriptions and MSreplication_subscriptions. If this
database is no longer a subscriber, then run sp_removedbreplication, which
removes the redundant system tables. If you want these tables to remain,
then simply locate the redundant record in the above relevant system table
and delete it.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment