Post reply

Publication deleted, subscribers still there

  • January 27, 2004 at 7:15 am

    #83374

    Hi

     

    We have deleted some publications becoz of different reasons. Later on we saw that some of the subscriptions are still there at the other server. We don't find any way to delete them. How can we delete this subscriptions.

     

    We really really need help with this. Don't find anything at MS technet. We are using Sql 2000 SP3.

     

    Thanx. A big hug for the helper !!!!!!!!

     

    El Jefe


    JV

  • January 27, 2004 at 12:08 pm

    #491812

    HI,

    Try 'sp_mergesubscription_cleanup' for merge or 'sp_subscription_cleanup' for transactional. You can read about those in BOL.

    Darius

  • January 27, 2004 at 2:15 pm

    #491825

    The subscriptions folder shows a union of the subscription metatables in each subscriber database. If you remove a publication before the subscription, orphaned records can be left behind and they don't really cause any problems, apart from being misleading. If you want a complete failsafe method (sledgehammer) you can use sp_removedbreplication in the subscriber database.

    Regards,

    Paul Ibison (http://www.replicationanswers.com)


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • January 28, 2004 at 12:31 am

    #491885

    thx Guys, finally found the answer in replication site !!!

     

    DAmn Microsoft !!


    JV

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply