http://www.mssqltips.com/tip.asp?tip=1021

Hi,

My query is regarding MS SQL Server Log Files.

As we know one of the difference between Delete and Truncate is after Delete, all the deleted data logs to log file which is not in case of Truncate.

If on Delete date goes to log file how we can retrive from it...

 I can find some software available on internet but is there any way from where we can retrive by sql query.

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 review and/or recover data in a user defined database transaction log.

This forum post also has some information on the topic - http://blogs.mssqltips.com/forums/t/514.aspx.

Thank you,
The MSSQLTips.com Team