I have a bit of a mystery. One of our local tables has been truncated and I can't figure out how or why. It is always possible that someone deleted the data through the application or with a query but its not likely.
Does anyone have any ideas of how I can investigate this further?
I can probably restore the data but I don't want this to happen again.
Thanks,Dale
Hi Dale
There is at least one tool around that will let you read the transaction log backups. I haven't used them, and when I looked, they weren't cheap... But if you really want to know exactly what happened, that should tell you, with a bit of hunting work.
In theory, anyway.
Ken