I am hoping that you can help me out. I had a SQL that got destroyed by someone re-initializing the disks on a RAID array and destroying the data. Here's the problem:
I have managed to restore the DB from a very old backup, and I tried replacing the MDF and LDF files with the ones that I recovered from a backup. The problem is that the new MDF and LDF files were not detached in the copy that I have, so when I start up the SQL server EM shows the DB as Loading/Suspect. I have tried restoring the database using sp_attach_db, sp_attach_single_file_db. I get the error The log for database DBName is corrupt' when I use sp_attach_db, and when I use sp_attach_single_file_db I get the error 'Database 'DBName' cannot be opened because some of the files could not be activated'
I am at my wit's end! I can't use the old backup (it is some months old), the RAID had the file backups (stupid place for them, same disk as the DB), and the last uncorrupted backup is the one I am using (a few months old). I retrieved the MDF/LDF files from tape of 5 days ago, that is acceptable for loss.
What can I do? Can a database be restored from an MDF file that wasn't de-attached first?
Help! I am putting all the points I have for this.