[From Builder AU
A coworker calls you in a panic because he accidentally deleted some production data, and he wants you to restore the lost records.
If you are lucky, you have a data auditing system in place, and you can restore these records from an audit table. If you do not have a tool that will read a transaction log so that you can undo transactions, you will likely need to restore the altered database to a certain point in time on the same or separate server than the server hosting the current database instance.
The article continues at