Recover deleted records Possible Duplicate:
  How do I get back some deleted records?  




Our C#.NET application mistakenly deleted all records from all tables of its database.
The application automatically takes backups, and the last backup it took after this delete is big in size, which means there must be useful data in the backup. The recovery model of the database is SIMPLE and I turned the server off after the records were deleted.

How can I recover the deleted records?
It sounds like, with your scenario, the easiest way would be to grab a backup of the database and restore it side-by-side your current database.  You need to ensure that this backup contains the deleted records.  Then simply do an INSERT INTO ... SELECT FROM ... to get the deleted records from the old database (via a backup/restored version) into your current.

If you don't have a backup of the database containing all of the data, you may be out of luck here.