Solved

Find deleted record from log file

Posted on 2013-11-05
5
457 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:
Bing CISM / CISSP 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now