Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email


Recover deleted records

01/02/2017 – in GoldMine, SQL queries

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

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.