Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Arrow Unanswered: Can't remove subscription info

    Dear All,

    I deleted a replication in the PROD server. However, the subscription info still exists in the subscription folder in the DR server.

    Can anyone tells me how to remove the subscription info? (When I delete the publication, there's a message saying we need to manually delete the subscription info in the subscriber)

    I'd tried restart the SQLAgent service, Disabling Publishing in PROD server but it's useless.

    thanks first.

    rgds.

  2. #2
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    The subscriber may be not online when u dropped the publication.
    Run sp_dropsubscriber at the publisher, see syntax in BOL. If it won't work; manually delete the subscription from the subscriber using Enterprise-Manager.

  3. #3
    Join Date
    Mar 2004
    Posts
    7
    Thanks TALAT.

    However, the sp_dropsubscriber won't work, i keep hiting error 14048.

    Anyway, my real interest is how to 'manually delete the subscription in EM' as mentioned by you...

    Details:
    At PROD server, publication is drop, there's NO item in Publications & Subscriptions Folder.

    At DR server, there's no item in Publications Folder, BUT there's 1 item (subscription) in Subscriptions Folder.

    Can you pls provide step-by-step details in how to delete the subscription info using EM?

    thanks...

  4. #4
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    Simply right click the subscription in the subscriber and choose delete. If u get error; run sp_mergesubscription_cleanup (if u r using merge replication) in the subscription db. It would clear all the subscription info.

  5. #5
    Join Date
    Mar 2004
    Posts
    7
    Thanks again TALAT,

    Extra info: Previously I'm using Transactional Replication. At the Subscriber, in the Subscriptions Folder, it shows 1 item of subscription with the Type: Push

    When I right-click on either the Subscriptions Folder or the Subscription itself, there's no Delete option to choose from, this is what bugging me.

    Any idea?

    Thanks first.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Mar 2004
    Posts
    7
    Thanks Satya, the link is useful.

    What's really bugging me is why there's no simple way to do this in EM?

    rgds

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Sometimes its better to follow system supplied SPs rather than depending upon Lazy GUI tools, as far as my exp. conveys.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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