Find deleted record from log file

Hello there,

I have an application which uses SQL server 2008 db. now one of the transaction in the app have gone missing. I am sure it has been deleted by the user. Is there any way to check in the log file of the database to find that. Appreciate your help.

cheers
Zolf
zolfAsked:
Who is Participating?
 
bbaoIT ConsultantCommented:
you may try to collect the active transaction log by querying fn_dblog with necessary filters, something like:

select * from fn_dblog(null,null)

Open in new window


the following article is a good reference.

FYI - How to read the SQL Server Database Transaction Log
http://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/
0
 
rajeevnandanmishraCommented:
Hi,

We are using ApexSql tool for this type of activity. It is easy to use, and really provides required information in time. Have a look at ApexSQL Log

For the time being, you can use the trial version also.
0
 
Sagir87Commented:
0
 
zolfAuthor Commented:
cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.