Recovering deleted records

hi Samuel Kim
Not sure if you ever found your answer, but there is an idea suggested which I think more peo0ple should vote for here:
https://sugarclub.sugarcrm.com/explore/enterprise-professional/i/product-suggestions/keep-deleted-records-for-30-days-in-recycle-trash-bin-and-allow-undelete

For a simple deletion this could work. But mostly such deletions were created by more complex operations like  e.g. merging of records. In the merging case, the relationships are deleted between the existing parts and newly created with the new parts. That makes it nearly impossible to restore the old relationships.

In an example I merged two contacts from one account to another account. The result in the accounts_contacts table looks like this and shows the problem to identify the changes:

For a simple deletion this could work. But mostly such deletions were created by more complex operations like  e.g. merging of records. In the merging case, the relationships are deleted between the existing parts and newly created with the new parts. That makes it nearly impossible to restore the old relationships.

In an example I merged two contacts from one account to another account. The result in the accounts_contacts table looks like this and shows the problem to identify the changes:

For the instances hosted on-site, I would suggest using the life-saving tool "Toothpaste" created by one and only Enrico Simonetti. It can restore the soft deleted records using a simple command. You just have to provide the module name and record id which you want to recover and it will take care of the rest.

I never tested the scenario Harald Kuske mentioned using this tool but I think it is capable of handling this situation as well.

Kind Regards,

Junaid