Administrator Best Practices Blog Misc

Four tips to maintain an effective Salesforce backup

What would happen if a new workflow rule or trigger ran amok on your Salesforce data without it being noticed for weeks? Or if a well meaning intern accidentally wreaks havoc while doing data cleanup? Would you be protected? The good news is that Salesforce backs up your data. The bad news is that their restore service is considered a last resort option and costs a minimum of $10k. Because of this, it’s important to take responsibility for backing up your data. One of the most straightforward ways to do this is to create a scheduled export of your Salesforce data. Once you have done that, here are some tips to make sure you protect your data:


1. Don’t forget to download the exports so that you actually have a backup. The Salesforce export process only creates a zip file that is stored for 48 hours in Salesforce. Salesforce sends an email when the export is available. The person receiving the email needs to make sure to download the zip file each week. I have been guilty of not doing this so I recognize how easy it is to say “I’ll do it later.”

2. Place the export file in a secure location. Your Salesforce system presumably has sensitive data that you have spent time setting up profiles and permissions for. Given that, you don’t want to copy the backup zip file (a set of unsecured spreadsheets that contains the Salesforce data) to your laptop or a file server location that the entire staff has access to. We recommend consulting your IT staff or an IT consultant to determine the correct secure location to store your backups.

3. Plan for how many export files you keep at one time. If you have a bad workflow rule or trigger creating bad data, it may be several weeks or longer before you notice the issue. If you are only saving the most recent export file, you will be out of luck when you try to restore the data. How many backups should you save? It really depends upon your database usage and the impact of a loss. One option would be to save weekly backups for the previous month and save a month end backup for the previous twelve months. Consult with your IT staff or IT consultant to determine how many backups to save.

4. Review your scheduled export whenever you add objects or add applications from the AppExchange. While you might expect that checking “include all data” would always export all objects, our testing has found that not to be the case. New objects added after scheduling an export are not included in the export. To have these exported, you need to go back into your scheduled export and choose “all objects” again or check those newly added objects.

One reply on “Four tips to maintain an effective Salesforce backup”