Home Forums SQL Server 2005 Data Corruption Can't drop, detach or set SUSPECT database to emergency mode RE: Can't drop, detach or set SUSPECT database to emergency mode

  • Ok. I did it by brute force. I stopped Sql Server. Renamed the data file. When I brought Sql Server back up, the database was no longer marked as "suspect" but it could not be accessed either.

    I issued EXEC sp_detach_db my_database. It returned with a warning but it appears to have worked. Then I just deleted the .mdf and .log files.