Help restoring database

[bladesk8er]

Hi,
problem is: transaction log files deleted.
: Database data files intact
thus database is 'suspect'
ANyone know how to recover from this situation - we dont care what was in the transaction log, just want the database back.

tia.

 

[MeanGreen]

In Books On Line (BOL), look up suspect database. There is some SQL you can use to remove the suspect flag and see if that will get you your database back. You might try to sp_detach_db and then sp_attach_single_file_db to see if that can recover your database. Of course, make sure you have a recent backup before trying any of this.

Hope this helps.

 

[bladesk8er]

Thanks,
my problem was that all recent backups had been damaged by faulty tape drive, and subsequent restores had trashed the transaction log files. Taking the database offline, then renaming the data files allowed deletion of the database while not losing the original data files, followed by re-creation with sp_attach_single_file_db. Phew. Doing a few dozen backups right now !