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 p2p
sp_removedbreplication @dbname = 'dbname'
Best,
ChrisBecker.blog
Chris Becker bcsdata.net
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
Chris Becker bcsdata.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy