I am in the situation that the Distribution database in SQL Server 2014 is lost and I want to disable the replication. I have found a solution how to achieve that when data files are present (also asked here). Unfortunately, I do not have data files of Distribution database. Is it possible to disable the replication when Distribution database is completely lost?

  • Do you have a good restorable backup of distribution database ? If yes, you can restore that with KEEP REPLICATION. If not, then you have to clean up replication bits from replication tables.
    – Kin Shah
    Nov 20, 2015 at 13:18
  • I was not backing up the distribution database, since it does not contain critical data. (However, it was not easy for me to find, how to disable the replication when the distribution database is lost.)
    – TN.
    Nov 20, 2015 at 15:23

1 Answer 1


Finally, I have found a solution. Problem was that I was calling the stored procedures from query windows of Management Studio (some stored procedures must be called from sqlcmd).

Then, it is enough to follow instructions for TSQL (with @no_checks and @ignore_distributor).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.