aprato, Agreed TRUNCATE is a minimally logged operation as well as under the code scenario you provide and/or with vendor tool the data can be recovered. Thank you for pointing out those items. Thank you, The MSSQLTips.com Team

tushar_kanaujia, Thank you for the post. This tip relates to the Management Studio tool to review SQL Server, SQL Server Agent, Database Mail and Windows logs, not how truncate or delete statements are logged in a user defined database transaction log. To the best of my knowledge vendors have tools to...