As TRUNCATE TABLE is a DDL, so log is not maintained for records that are truncated, resultantly. Only way to bring them back is Point in Time Recovery.
TRUNCATE TABLE is logged but in a minimal fashion. You can detect it using the fn_dblog function, it's an undocumented function but there's details about it here:
You'd probably have to experiment with fn_dblog to differentiate between a DELETE and a TRUNCATE TABLE.
A better option may be to set up a SQL trace for TRUNCATE TABLE operations and leave it running. As long as you're not performing many TRUNCATE TABLE the trace file should remain small. None of these will help you recover lost data, you'd have to restore from backups.
Metadata about truncation
Posted - 09/07/2012 : 13:12:00
