In transaction log sunt inregistrate toate modificarile datelor (valoarea veche si valoarea noua a fiecarui rand modificat). Transaction log-ul poate fi afisat cu comanda nedocumentata DBCC LOG (vezi http://www.windowsitlibrary.com/Content/77/21/1.html) sau, mai bine, cu utilitare third-party:

Lumigent Log Explorer - http://www.lumigent.com/products/le_sql.html

Apex SQL Log - http://www.apexsql.com/sql_tools_log.asp

Red-gate SQL Log Rescue - http://www.red-gate.com/products/sql_log_rescue/index.htm

Razvan