Recovering from a Database Failure
“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 ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
