Post reply

Serious Problem

  • July 16, 2008 at 12:56 pm

    #381730

    I hope you guys have an answer for me. Here's the scenario:

    Transactional Replication with initial Snapshot:

    Server1 - Publisher

    Push Subscription to Server2

    Server2 - Subscriber

    Distributor located on this server

    We just lost Server2. Lost as in, it crashed and isn't coming back. I obviously need to break/delete replication but it will not let me because it's looking for Server2 and just throws up errors whenever I try to delete the subscriber or publisher.

    Please help!!!

  • July 17, 2008 at 2:03 pm

    #844645

    Take a look at :

    sp_removedbreplication @dbname = 'db_name'


    * Noel

  • July 21, 2008 at 8:47 am

    #845790

    noeld (7/17/2008)

    Take a look at :

    sp_removedbreplication @dbname = 'db_name'

    Thanks for this tip ... I just recently came accross a scenario where other means to remove the replicated DB failed.

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

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