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

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

I agree with Vincent Amari as this is not an available feature in Sugar today. If the instance is hosted in SugarCloud, it's best to open a case with our Support team with the details of the record that was deleted so that they can try to do the restoration. If the instance is hosted on-site, the relationship deleted flags would all need to be restored based on the deleted record's ID and date modified. This is likely something that the database administrator would want to script if possible since it could be a very long manual process. 

The Product Suggestion that Vincent shared is also associated with Enhancement Request 70073, but there is no expected timeline on this functionality at this time. 

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: