go to link-
http://raresql.com/tag/recover-deleted-data-from-sql-server/
create stote proc and check all dleetd records
plxz click for above link
Select [RowLog
Contents 0]
FROM sys.fn_dblog(NULL, NULL)
WHERE AllocUnitName =
'dbo.admin_Login'
AND
Context IN ( 'LCX_MARK_AS_GHOST', 'LCX_HEAP' )
AND Operation in ( 'LOP_DELETE_ROWS' )
No comments:
Post a Comment