Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: Find out who deleted rows?

    Yesterday, I had an occurence where someone (one of our developers ) deleted many vital rows in a database. I was able to recover via a backup but I'd like to see what was run to delete those rows, when and who if possible? I have the transaction log and the _log.ldf.

    Can I read those somehow to find out this information? I have since added auditing to said tables, but I'd really like to go back and see what happened?

    I do know about Lumigent, but is there a different production/solution?

    Thoughts?

    Thank you

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you add triggers? Write all transaction to a history table...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Posts
    7
    Brett.

    See above, "I have since added auditing to said tables, but I'd really like to go back and see what happened?".....

    Thanks for the thoughts though.....

    Anybody else on the read log file or transaction log files?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •