Solved

Find deleted record from log file

Posted on 2013-11-05
5
471 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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 insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

632 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