How to get deleted record

Question

Hi Can we get deleted records from database? if yes how? Thanks.

Datta Kharad · Answer

Hi Did you get answer or not?

Vijay Yadav · Answer

Please mark the answer that help you!

Datta Kharad · Answer

Hi You can get deleted record from sql server using this command.. Select [RowLog Contents 0] FROM sys.fn_dblog(NULL NULL) WHERE AllocUnitName = 'dbo.TableName' AND Context IN ( 'LCX_MARK_AS_GHOST' 'LCX_HEAP' ) AND Operation in ( 'LOP_DELETE_ROWS' ) Also refer this link http://dba.stackexchange.com/questions/995/get-deleted-records

Prabhu Raja · Answer

I am not sure about that we can access the table rows once it was deleted from database. But some strategy will make it possible i think 1) create a new table that will have the same structure of an existing one. 2) Create a After Trigger for delete Operation and place the deleted row in to the new table. 3) So you can get the deleted rows at any time from newly created table.