Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010

    Unanswered: 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.

  2. #2
    Join Date
    Feb 2010
    Have you deleted the job/agent that defines the publisher?

Posting Permissions

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