February 2, 2018 at 3:48 am
I have p2p replication set up between 2 2005 boxes.
I need to remove p2p from the databases involved. I cannot use the topology wizard, because it does not work.
How do I achieve this?
August 13, 2018 at 10:05 pm
Expand replication node and drop subscription at one node, then drop publication at other. Then run the below which will blow away all publications in your db, careful if you have more than p2psp_removedbreplication @dbname = 'dbname'
August 13, 2018 at 10:06 pm
Sorry I meant first drop subscription, then drop publication at one node, do same at other. All under the Replication folder in SSMS
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply