web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How to restore deleted record ?

(0) ShareShare
ReportReport
Posted on by 815

Hi,

On the premise CRM, a case record is deleted, what is the best way to restore the record from back-end ?

Please help.

Regards

Faisal

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    14,065 on at

    There are several options, each with different pros and cons. First, you'll need to find the data that was deleted; if you had auditing enabled at the time the record was deleted, then you can find the data in the audit log. If not, you'd need to restore a SQL database backup (restore it to a new database) from a time before the deletion.

    Then you'll need to recreate the case. The main options are:

    • You could just enter the data as a new case. However, this will get a new ticket number, and new createdon date
    • You can programmatically create the record, which allows you to specify the ticket number, and lets you override the createdon date (using the overriddencreatedon field)
    • You could use a hybrid, though unsupported approach. You could manually create the case in CRM, then in SQL update the ticket number field to the previous value. As stated, this would be unsupported
  • Verified answer
    Syed_Faisal Profile Picture
    815 on at

    Thanks David,

    I got this tool but not sure how strong is this.

    www.cobalt.net/.../dynamics-crm-snapshot-how-to-recover-deleted-records

  • Suggested answer
    bac26 Profile Picture
    2,268 on at

    There is no way to "restore" the one record while keeping everything in tact.      We recommend letting people make cases inactive or canceling them but we do not give anyone but Admins the right to delete for this very reason.

  • Suggested answer
    Pawar Pravin Profile Picture
    5,237 on at

    Hi Syed,

    I'm using same managed solution and I believe it's secure to use. You can use cobalt solution to restore record.

    Regards,

    Pravin

  • Syed_Faisal Profile Picture
    815 on at

    Thanks Pravin for conforming !

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans