Solved

Find deleted record from log file

Posted on 2013-11-05
5
459 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

I have a large data set and a SSIS package. How can I load this file in multi threading?
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

770 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