I've inherited the following problem and really need some of your great advice: Server crashed hard (two raid-5 drives in 12 hours), only backup available of sql database is the actual file backup of the MDF and LDF files which were made using file locks with BackupExec. This pair of files, when put in place and attempting to attach, give error 3456: cannot redo the log. I have tried putting the database in emergency mode and swapping around the MDF files, which allowed me some access to the data, but when I DBCC checkdb it's full of page errors, allocation errors, trashed indexes, and lots of error messages, etc. I spent hours dbcc'ing and it is now running cleanly.
I just wanted to make sure that the method I followed was the best route to follow as I am sure there is critical data missing. Looking for some guidance and confirmation, or an alternate method to try. This problem is unique from others I've researched in that I actually have both database files, but since they were backed up one after the other with the system live I guess they are not in sync and cannot be directly attached?
I consulted this article and tried everything listed: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21088296.html?qid=21088296
Would appreciate any input. This database is fairly large and would be a total disaster to lose. I already gave them the "I told you so" and "backup often" speeches ;)
NOTE: I will open up additional questions relating to this so I can award 500 points to every person with good solutions.
Thank you very much.