How to read LDF file? sql 2000

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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

  • 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

  • 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

  • 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