Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    49

    Unanswered: How to remove replication?

    Hi, all.
    I have two server(Svr01, Svr02) that are replicated each other (Merge replication).
    Svr01 must be Publisher distributor.. but, by mistake Svr02 is set to distributor, publisher. (Publisher/distributor are on the same comp..)

    I want to fix this..
    How?

    I think I have to remove replication on both side and Reset from the first.
    but, I don't know how to remove replication either..

    Please reply with any thougt....
    MCSD .NET, SCJP, SCJWD

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Use Replication menu option in EM. You can also check stored procedures that can be used to remove it manually (they are all executed in the background when you do it through GUI), but start with EM first.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2004
    Posts
    49
    Quote Originally Posted by rdjabarov
    Use Replication menu option in EM. You can also check stored procedures that can be used to remove it manually (they are all executed in the background when you do it through GUI), but start with EM first.
    I don't understand about EM..
    Could you explain more detail..?
    MCSD .NET, SCJP, SCJWD

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    EM is SQL Enterprise Manager.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •