Did you know Red Gate gives SQL Log Rescue for free?
I thought I mention this, since these types of tools are rarely needed, but when they are, they are also seriously saving your ass. :-)
SQL Log Rescue is basically undo tool which analyzes transaction logs of your SQL Server database and allows you to undo and redo transactions. You can for example restore the 100 million rows you just accidentally deleted from your customer's database :-)
Feature set of SQL Log Rescue:
- Automatically generate the SQL scripts to undo and redo transactions.
- View and analyze SQL Server transaction logs.
- View large objects (e.g. ntext and image columns).
- View and recover deleted and modified data.
- Group and sort information in a custom-written, high performance grid.
- Search transactions.
- View row history – understand all the activity on a row-by-row basis
And what's amazing, this tool is now free!
You'll find more information at: http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
NOTE: it doesn't work in SQL 2005 (explained at: http://www.red-gate.com/messageboard/viewtopic.php?t=5983) part of why it's now free