Home Forums SQL Server 7,2000 Replication Cannot drop the database XXX because it is being used for replication. RE: Cannot drop the database XXX because it is being used for replication.

  • May 11, 2004 at 6:43 am

    #505950

    Please, run sp_helpreplicationdb to check with databases are marked for replication.

    Distribution is for replication but should not be marked for replication, so you should be able to restore it at any time.