O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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!

images 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required