Sometimes, the internet is a wonderful place! There are some outrageously clever people out there donating their expertise for free. One such is a fellow called Muhammad Imran who has written a stored procedure that can recover deleted records from SQL tables by using the transaction logs. You can find it at https://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/.

It’s not a miracle cure, and it may not bring back all you’ve lost, but it does give you one more tool to try when disaster strikes.

The stored procedure returns a results set that contains the deleted records that it was able to find but doesn’t actually push them back into the database.