“Orphaned transaction log!”
The first thing you should always think of whenever a database has failed in SQL Server 2005 is whether you can recover the orphaned transaction log. The orphaned transaction log represents all the changes to the database since the last transaction log backup. If you can back up these changes and apply it in your database recovery procedure, you have lost no committed transactions in your SQL Server 2005 database solution. That's a worthwhile pursuit!
In SQL Server 2005 Books Online, the orphaned transaction log is referred to as the tail of the log or tail-log.
But…it all stems ...