Restore of Dynamics CRM failed

  • 46Views
  • Last Post 29 January 2018
0
votes
Phil Marsden posted this 23 January 2018

Hi, I have performed a backup of our Dynamics CRM but the restore failed almost immediately with:

Object 'accountleads' doesn't support update operations.

Also I'd like to test restoring our live backups to a sandbox instance but didnt see an option to do this 

 

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 24 January 2018

Object 'accountleads' doesn't support update operations.

This is an expected error and it is related to Dynamics CRM peculiarities. Some Dynamics CRM entities are read-only and do not support insert/update/delete operations. These entities can be backed up, however, restore is not supported for them .Please refer to:

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/entities/accountleads

https://skyvia.com/resources/docs/index.html?dynamics_connections.htm

 

As for restoring to Sandbox, first of all, you need to create your Sandbox connection in Skyvia and then follow instructions here:

https://skyvia.com/resources/docs/index.html?how_to_restore_data.htm (Restoring Data to Other Connection)

 

Best regards,

Mariia

0
votes
Phil Marsden posted this 24 January 2018

Hi, 

 

As described in the article, I have set the filter to be "IsMaster=True" but i get no objects shown

Also, If restoring to a different connection is only valid of "Insert Records" do I need to clear out all existing records first?  How do I do that?

0
votes
Mariia Zaharova posted this 29 January 2018

I have set the filter to be "IsMaster=True" but i get no objects shown

Please describe the issue more clearly, e.g. what exactly steps you are performing, what exactly objects do you mean, send us screenshot which demonstrates this issue.

If restoring to a different connection is only valid of "Insert Records" do I need to clear out all existing records first?  How do I do that?

You can use Query Tool for this. Open Query Tool, select New SQL and then select the necessary Dynamics CRM connection and perform delete query for the necessary object, for example:

DELETE FROM your_table

 

Close