Solved

Find deleted record from log file

Posted on 2013-11-05
5
460 Views
Last Modified: 2013-11-08
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
0
Comment
Question by:zolf
5 Comments
 
LVL 37

Accepted Solution

by:
bbao earned 125 total points
ID: 39626500
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
 
LVL 9

Assisted Solution

by:mimran18
mimran18 earned 125 total points
ID: 39626681
0
 
LVL 9

Assisted Solution

by:rajeevnandanmishra
rajeevnandanmishra earned 125 total points
ID: 39627061
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
 
LVL 3

Assisted Solution

by:Sagir87
Sagir87 earned 125 total points
ID: 39628017
0
 

Author Closing Comment

by:zolf
ID: 39635298
cheers
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question