Schedule export backup of your Salesforce Data – Interview Question

Salesforce allows you to obtain a copy of all your data using the data export feature.  You can generate backup files manually once every six days or schedule them to generate automatically at weekly or monthly intervals.  The backup file will come to you in the form a zip file that contains all of your organization’s data in a set of CSV (comma-separated values) files.  If you do not see the data export feature, contact to have the Data Export Service activated.


Step by Step Instruction:

  1. Click Setup >Data Management > Data Export > Schedule Export.
  2. Select the desired encoding for your export file. Leaving the default is fine.
  3. Check the Include in export checkbox if you want to include attachments in the export (optional)
  4. Leave the default Replace carriage returns with spaces if you want your export files to have spaces instead of carriage returns.
  5. Select Weekly as the the frequency for the exports.
  6. Choose start and end dates. Set the end date to sometime in the distant future such as 20 years from the begin date.
  7. Set the time of day for your scheduled export. The export is put in a job queue and the exact time of the export will depend on the amount of activity in the queue.
  8. You can select the types of data to include in your export. It is best to include all data in your export file. This will make sure all your organizations data is exported.
  9. Click Save.

Points to Remember:

  1. Formula and roll-up summary fields are never included in exports.
  2. Articles are not included from exports.
  3. The export notification email is sent to the email address on file for the user who created the scheduled export. There is no way to indicate another email address. If as an Administrator you want the email to go to another person, have them grant you login access, login as them and schedule the data export.


  1. Scheduled backup exports of your data is limited to weekly exports.
  2. You have 48 hours from the time you are notifiedthe backup is available to download the backup file.
  3. The email notification for backups goes to the email address in Salesforce of the person logged in who schedules the backup


  1. That backup is only allowed to be done weekly so we have been working on a product called DataTrailer that backs up your data much more regularly and captures all the change history for all fields. This way you don’t have to worry about forgetting to download the backup files. Here is our site explaining it:

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.