Remove replication components with Publisher database deleted

  • Before I reinstall SQL Server, has anyone successfully removed ALL replication components from an installation when the publisher has been manually dropped? I've got components everywhere still present but no databases, I inherited this situation and would like to remedy prior to spending all day reconfiguring the 2005 Standard instance.

  • Did you try sp_removedbreplication '<Database name>'? This has to be run on the pubisher and subscriber.

    -Roy

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

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