Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    4

    Unanswered: drop subscription

    is there anyone know how to drop subscription from the publisher database without a connection to the subscriber(because the subscriber server is formated)

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can certainly do this using the replication stored procedures, but the GUI can't do it for you. You'll need to get someone that understands both SQL Server replication and your environment in order to do this safely. Microsoft Professional Support Services will help you work through this for a fee.

    Another alternative is to backup the database, drop the database, then restore the backup. This is simple and except for the down time relatively painless.

    -PatP

  3. #3
    Join Date
    Dec 2006
    Posts
    4

    i need to drop subscriptions for one subscriber

    actually the backup, drop and restore solution is the easiest way but you can do that in a test environment but I have a live environment of 50 subscribers and if I want to create a snapshots for these subscribers it'll take a lot of time that’s for coping a bout 800MB at least throw a WAN network
    However, you can drop the publications and rebuild them on the publisher database.
    You cay find the sp_dropsubscriptions but it's not working good
    I'm trying to reach someone can drop the subscription for one subscriber only without dropping all publication

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I can do it, and I'm sure that some of the folks here on DBForums can do it, but I don't know any simple way to describe how to do it. You really need to understand how SQL Replication works, and how your particular setup is configured.

    I'm sorry, but I don't know of a simple solution to your problem.

    The cheapest answer long term is likely to be to call MS-PSS and ask them to walk you through the process. It will cost you some money, but only a tiny fraction of what rebuilding whole databases might cost.

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