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.

  • Worked like a charm with "Offline" mode!

    I had a interesting situation: my database was in Warm Standby mode, and I had a .tuf file deleted. The releiving thing was that I didn't needed this database anymore, but I couldn't delete it because of remained publications from primary log shipped database. The publication couldn't be deleted, of course, because the DB was read only. The DB could not be recovered because of missing tuf file.

    The only solution that worked was putting the DB to offline mode, and then deleting manually the data and log files. Also the publication disappeared.

    Thanks!