Recovering deleted records

Hi,

I'd like to ask a general question regarding best practices. In cases like when a client mistakenly deletes a record from any Sugar module, such as Accounts, what is the best way to go on about recovering it? Simply changing the record's deleted flag back to false using SQL seems like the most straightforward way, but what about the record's relationships? Do I have to set their flags back to false one by one? Or is recovering a deleted record not recommended at all?

Any insight on the matter would be appreciated.

Regards,

Samuel.

Parents

0 Vincent Amari over 4 years ago

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

.

CRM Business Consultant
Cancel
Vote Up +3 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alex Nassi over 4 years ago in reply to Vincent Amari

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.

Alex Nassi
Digital CX Operations Director
SugarCRM
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Alex Nassi over 4 years ago in reply to Vincent Amari

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.

Alex Nassi
Digital CX Operations Director
SugarCRM
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data