Tags: backup, database, deleted, developers, microsoft, mysql, occurence, oracle, recover, rows, server, sql, via, vital

Find out who deleted rows?

On Database » Microsoft SQL Server

879 words with 2 Comments; publish: Wed, 05 Dec 2007 00:29:00 GMT; (250203.13, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • Did you add triggers? Write all transaction to a history table...
      #1; Tue, 11 Dec 2007 16:21:00 GMT
    • 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?

      #2; Tue, 11 Dec 2007 16:22:00 GMT