Distributor issue

  • Hi All,

    I have done snapshot replication setup and now I am deleting the setup. After deleting the subscriber,publisher, I am trying to remove distributor for which i am getting the below error.

    -------------------------------------

    Drop failed for LinkedServer 'repl_distributor'. (Microsoft.sqlserver.smo)

    Can not drop server 'repl_distributor' because it is used as a Distributor in replication. (Microsoft SQL Server, Error 20581)

    -------------------------

    I have also deleted the linked server but still getting the above error.

    Please help me to resolve the issue.

    Thank you.

  • First run sp_dropsubscriber in the publisher database and then run sp_dropdistributor at the distributor.

    You can find the option for running these commands in Books On Line.

    -Roy

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

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