Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joker77
Starting Member
4 Posts |
 Posted - 2010-11-11 : 07:15:12
|
| Hi there,We had an issue overnight when some of our data was deleted. Specific rows from specific tables.We have backup files (.bak) from before and after, and Transaction Log Files (.trn)How can I use these to tell when the data was deleted, and by who?ThanksNeal |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-11-12 : 16:54:06
|
| search on 3rd party tool, log readersthey usually have eval versions which you can try--------------------keeping it simple... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-13 : 05:15:15
|
| FWIW (bit late now, but perhaps worth considering for next time) we have Triggers on all our tables (all the ones that matter) for UPDATE and DELETE that store the "before" data into an audit table (each table has a "parallel" Audit Table, same columns as main table but with additional Date/User columns).Useful for accidents, diagnosis, fraud investigation ... etc |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Data deleted - how to tell when (using .trn)