January 11, 2012 at 2:55 am
How can I read LDF file? My table is missing from database, and I want to know how it has been removed. Therefore I need to read the transactions registered in LDF file
January 11, 2012 at 3:14 am
For SQL 2000 you can get SQLLogRescue from Redgate (it's free), but depending how long ago the table was dropped, it may not be in the tran log any longer
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2012 at 3:51 am
Many thanks for your prompt response. I installed it and used it to read the LDF file. Now the problem is that although I am sure that the Table was created many years ago, the transactions shown start from 09/01/2012 10:41 and the table is dropped between 4:00 AM and 6:30 AM on 09/01/2012
January 11, 2012 at 3:57 am
Then the drop table log records are no longer in the transaction log (its a transaction log for database recovery, not an audit log) and, unless you had some other form of auditing you won't be able to tell who dropped it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2012 at 4:08 am
I agree with Gail in your case.
Just for your reference, you may keep this link handy for future use.
Finding out who dropped the table using transaction log
M&M
January 11, 2012 at 6:23 am
But you have a good backup you can go to and retrieve everything, right?
If not, why not?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2012 at 9:15 pm
Grant Fritchey (1/11/2012)
But you have a good backup you can go to and retrieve everything, right?If not, why not?
Yes Grant, absolutely 🙂
M&M
April 9, 2016 at 1:44 am
This was removed by the editor as SPAM
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply