Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    76

    Unanswered: dropping replication

    Hi,
    Is there any way to drop a single replication. one subscriber server was taken down without dropping first. Now I have a pull at publisher which is in state of reinitialized and waiting for the server to be back on.
    I don not want to drop all replication and create them again. So I wonder if there is anyway to just drop that single replication belong to the taken off server.

    Thanks for the help in advance.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: dropping replication

    Yes, just execute 'sp_dropsubscription' with the correct parameters in the publication.

    Just for future references, the pull subscription should be dropped in the subscriber before you take the server down.

  3. #3
    Join Date
    Nov 2003
    Posts
    76
    ty.
    Edit:
    according to BOL.
    sp_dropsubscription is used in snapshot and transactional replication.
    but this is merge.
    Last edited by sivaroo; 12-05-03 at 11:41.

  4. #4
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: dropping replication

    Did you mention it was a Merge?

  5. #5
    Join Date
    Nov 2003
    Posts
    76
    yup it is merge replication. I am sorry I didn't mention on first msg.

Posting Permissions

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