Tags: backup, database, deleted, developers, microsoft, mysql, occurence, oracle, recover, rows, server, sql, via, vital
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?
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
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