Hi,
I have used the 'Disable Publishing and Distribution wizard' to remove all
publications and subscriptions and it went successfully. But why is there a
subscription item listed in the 'Subscriptions' folder under the
'Replication' folder in the SQL enterprise manager in both the publisher
server and the subscriber server? How can I remove it?
Wingman
As you've disabled replication, you can run sp_removedbreplication on each
database that has these remnant replication system tables.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Friday, March 23, 2012
Lingering subscription after disabling Publishing and distribution
Labels:
allpublications,
database,
disable,
disabling,
distribution,
lingering,
microsoft,
mysql,
oracle,
publishing,
server,
sql,
subscription,
subscriptions,
successfully,
wizard
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment