SQL 2005 Peer-To-Peer Replication Issue

  • 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?

  • 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

  • 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