Vertigo44 (12/27/2011)
Being that there were no successful backups, wouldn't this mean that all transactions from the beginning are in the LDF and were never commited to the MDF? Please correct me if I am wrong.
You're wrong. A backup is a backup, a copy of the data to another location. Nothing whatsoever to do with transactions in the log
Could I copy the MDF to another server and to a restore with ALLOW DATA LOSS (http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx)
It's about the only option you have left. I wouldn't bet much (if anything) on the uncorrupting of the drive. I've never seen a mdf, ndf or ldf recovered that way having been usable afterwards.
Switch the database to emergency mode, then to single user mode, run checkDB with the repair_allow_data_loss option. It will lose data, it may not work. If it doesn't work, there's no further alternatives, this is the very last resort.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability