Can a truncated table be recovered using the Recover Table Wizard?
Yes, truncated tables data can be recovered using the Recover Table Wizard. Below is taken from the Toad for SQL Server help file:
Use the Recover Table wizard to recover a table that was dropped or truncated, as recorded in the transaction log. The Log Reader re-creates the table in the database and reloads the data.
For more information, please refer to the Help file under Recover Tables topic.
