locked
Recover deleted records in Dynamics CRM RRS feed

  • Question

  • My Dynamics CRM 2011 is configured on premises environment and, in order to be able to plan ahead, I need to know what recovery options are available here

    I plan on doing weekly and daily backups but, still, the errors may occur (e.g. accidental record deletion happens @ 6PM and last daily backup was @2PM, which means that the data is not going to be in the backup)

    I know that older Dynamics CRM versions had soft delete, so it was easy to undelete records but this is not the case in 2011 version.

    Thanks for your help in advance.
    Friday, May 17, 2013 9:42 AM

Answers

  • You may be able to prevent data loss or recover deleted data by doing following:

    Check (http://blogs.msdn.com/b/crm/archive/2011/05/23/recover-your-deleted-crm-data-and-recreate-them-using-crm-api.aspx) article to understand how to setup auditing for the most important data, in order to be able to recover the data by using database audit data and SKD.

    See if you can reduce user privileges so that only admins can delete records.

    See if you can create differential backups every hour or so.

    You could also use third party tools – check out sql recovery tool (http://www.apexsql.com/sql_tools_recover.aspx) and transaction log viewer tool (http://www.apexsql.com/sql_tools_log.aspx), from ApexSQL. These claim they can recover deleted data by reading transaction log.
    Friday, May 17, 2013 9:48 AM

All replies

  • You may be able to prevent data loss or recover deleted data by doing following:

    Check (http://blogs.msdn.com/b/crm/archive/2011/05/23/recover-your-deleted-crm-data-and-recreate-them-using-crm-api.aspx) article to understand how to setup auditing for the most important data, in order to be able to recover the data by using database audit data and SKD.

    See if you can reduce user privileges so that only admins can delete records.

    See if you can create differential backups every hour or so.

    You could also use third party tools – check out sql recovery tool (http://www.apexsql.com/sql_tools_recover.aspx) and transaction log viewer tool (http://www.apexsql.com/sql_tools_log.aspx), from ApexSQL. These claim they can recover deleted data by reading transaction log.
    Friday, May 17, 2013 9:48 AM
  • Thanks Lemar, I'll check this out.
    Friday, May 17, 2013 9:50 AM
  • Hi ,

    Enable auditing for the most important records – even if data is deleted you should be still able to recover using database audit data and SKD. Check this article for more details.

    Review user permissions – see if you can reduce user privileges so that only admins can delete records.

    Make more frequent differential database backups - see if you can create differential backups every hour or so.

    Use third party tools – check out ApexSQL Recover and ApexSQL Log . These tools claim they can recover deleted data by reading transaction log.

    Best Regards

    Meena


    Friday, May 17, 2013 10:19 AM