Performing Salesforce Record-level Restore Operations


You can restore the selected records of a selected object to a file system or to a Salesforce instance. You can only restore records from the latest backup cycle.

If your Salesforce environment has the Persons Account feature, then make sure that you select the Account Object when you want to restore the Person account records. You must make this selection even when you have deleted the account record from the contacts. For more information about the person account feature, go to the Salesforce help site, Person Accounts.

Tip: To avoid errors or for faster results, disable the validation rules, Apex triggers, and workflows. For the same benefits for managed packages, uninstall the packages. (Managed packages cannot be disabled using APIs.)

Before You Begin


  1. From the navigation pane, go to Protect > Applications > Salesforce.

    The Salesforce page appears.

  2. Click the action button , and then click Restore.

    The Select restore type page appears.

  3. Click Record level restore.

    The Backup content page appears.

  4. From the Object list, select the object that you want to restore.

    The records for the selected object appear in a table.

  5. Optional: In the upper-right of the page, filter the records:

    • To filter by version, select the versions that you want to view.

      • To show the latest record version, select Show latest version.

      • To show the all versions of the records, select Show all versions.

      • To show the deleted records, select Show deleted records.

    • To filter by SQL, click Advanced filter not set, and then select Set advanced filter.

      The Advanced filter dialog box appears.

      • In the box, type a valid SQL query, and then click OK.

  6. Next to the records that you want to restore, select the check box.

  7. Click Restore.

    The Restore options dialog box appears.

  8. Next to Restore target, select the restore target:

Restore target



  • Under Destination details, from the Destination organization list, select the Salesforce destination.

File system

  1. Under Destination details, from the Destination server list, select which server to restore the data to.

  2. In the Destination path box, enter a path to restore the data to.

  1. Under Options, set the restore options:

    • To include parent objects in the restore, from the Parent objects to restore list, select All parents.

      Important: Including parent objects has the following effects:

      • Data integrity is maintained. If parent objects are included and some parents do not exist or some parents have incorrect values, restore operations will complete.

      • When objects such as User objects are updated, end users will receive notifications, which may not be desirable.

    • To include child objects in the restore, from the Child objects to restore list, select the child objects.

      • To exclude some child objects, select the Exclude children check box, and then in the Children to exclude box, select the child objects that you want to exclude.

    • To disable the Salesforce triggers and rules, select the Disable triggers and rules check box.

      After the restore is complete, the workflows and triggers are automatically enabled.

    • To apply data masking, select the Apply masking on destination check box, and then from the Select data masking policy list, select the data-masking policy.

      Note: Data masking can be applied when a cross-instance restore is run and data masking policies are defined.

  2. Click Submit.

SQL WHERE Clause Examples for Salesforce Restores