SQL 2005 Peer-To-Peer Replication Issue

  • mate 99258

    SSC Rookie

    Points: 36

    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?

  • Chris Becker

    SSCrazy

    Points: 2503

    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

    SSCrazy

    Points: 2503

    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