Post reply

SQL 2005 Peer-To-Peer Replication Issue

  • February 2, 2018 at 3:48 am

    #343810

    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

    #2001574

    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

    #2001575

    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