Despite Salesforce’s clear recommendation to invest in a third-party backup solution, many businesses still use Data Export to create backups of their Salesforce data. Gearset’s State of Salesforce DevOps 2024 report reveals that while 87% of businesses have a backup solution or plan to implement this year, 24% back up their orgs using Data Export. But Data Export falls short in several ways as a tool for any backup and restore operation, let alone for disaster recovery.
Backups are only useful if you can restore the data
Data restoration is the process of recovering data from backup files to a Salesforce org. Exporting backup data is just one part of a viable backup strategy for protecting, managing, and restoring your business-critical data. The real test is data restoration. Can you restore data accurately from your backups? How long does it take your team to restore? And how much of the data can you restore successfully?
Your ability to restore data quickly and accurately depends on your ability to restore metadata as well as data — something teams often overlook. You need metadata backups, not just because the configuration described by metadata is valuable, but because it’s needed to make sure you can restore data. Records can’t be restored to fields and objects that no longer exist or have been altered.
Data Export can’t back up your metadata. It only generates CSV files of your data, which you can then store as backups. Trying to restore data without a metadata backup normally involves recreating metadata first to prepare the org, and this massively delays data recovery. Unless the org’s metadata is restored to the state it was in at the time of backup, you may be unable to restore the data.
Gearset’s backup solution backs up both data and metadata every time a backup job runs. Whether you’ve lost a handful of records that you can’t find in Salesforce’s recycle bin, or an entire object has blown up with all of its fields, records and relationships, Gearset has you covered.
An expert evaluation of Data Export
Eric Kintzer, Salesforce Architect and one of Gearset’s community advisors, has first-hand experience of using Data Export for backups in the past. He shared this assessment of trying to restore data from the CSVs it provides:
“Restoring data from CSVs is exceptionally difficult, especially when relationships are involved - intermediate VLOOKUP Excel columns to reconstruct relationships may be needed. The CSVs are large and hard to manipulate in Excel due to memory limits or row limits, and an object might span multiple CSVs. Restoring files or attachments is especially time-consuming.”
Eric went on to explain how easy it can be to corrupt backup data when trying to restore:
“If you open a CSV in Excel and edit it, you’re almost guaranteed to get data corruption when you save the file. For example, a zip code such as 01234 will be saved as 1234, dates may not save in ISO format, and Excel tends to mess up fields with embedded line breaks — all of which make these records unrestorable.”
Unfortunately, Data Export won’t help when it comes to restoring your org. Eric recommends that every company test their restore plan to get a true understanding of their vulnerability in the event of any data loss: “A company relying on Data Export is merely checking a box that they have a backup strategy; it’s highly unlikely they have ever tested a restore from Data Export and are blithely hoping they will never have to.”
Data Export limits how often you can back up data
Effective disaster recovery isn’t just about how quickly you can restore data — your recovery time objective (RTO). It also depends on how recently you last backed up data — your recovery point objective (RPO). Restoring outdated data isn’t good enough, so most businesses want an RPO of 24 hours or under. In other words, you need to back up your data and metadata every day.
With Data Export, you can only export your data once a week at most. And if you’re using a Professional Edition org, you can’t export data more than once a month. What’s more, Salesforce itself warns that a scheduled export can be delayed by as much as one week, sitting in a queue for delivery due to heavy traffic. The Data Export backups have to be manually downloaded, one zip file at a time from Salesforce to your local file system. This imposes a burden on the system administrator who has to babysit perhaps dozens of download tasks, hoping not to forget any.
In contrast, Gearset generates daily backups automatically and efficiently. That’s at the very least; if you have certain objects that are constantly changing and so need an even more stringent RPO, no problem! You can use Gearset’s high-frequency backup jobs that run every hour. Consider how much data is added to your org in a typical month — or even in the average week. Can you afford to lose that data?
Data Export creates a security and compliance headache
Data security and compliance apply to your data wherever it’s held — not just in production. Your backups must be protected and managed to the same regulations and standards. Data Export leaves you to manage your backup data yourself, once the CSV files have been delivered. This means that using Data Export isn’t cost-free, because the expense of storing, protecting, and managing backup data falls to your business.
By handling all data security and compliance in-house, you also take on the risks. To stay compliant with regulations like GDPR, CCPA, or SOX, you’ll need clear solutions to challenges such as:
- Access control: Who will have access to the backup data?
- Data protection: How will the data, especially personally identifiable information (PII), be kept secure?
- Retention policies: How long will you keep backup data for?
- Right to be forgotten: If a customer invokes their right to be forgotten, how will you purge their records from all of your backup files?
These are difficult and often costly problems to solve, and dealing with backup data in-house makes you liable for them. Configurable permissions, audit trails, and retention rules in Gearset simplify compliance without slowing down your business.
A trusted and well-designed backup solution takes the pain out of security and compliance. When you use Gearset for backups, your data is encrypted in transit and at rest for enterprise-grade security, and stored on Gearset’s servers in the same AWS data centers used by Salesforce.
Gearset’s backup solution gives you a configurable permissions model for data backup jobs, so you can manage who has access to each part of the backup job’s functionality. This keeps backup data secure, but means it’s easy to delegate access if and when needed during a restore scenario.
With Gearset, you also get all the tools you need for compliance with data protection legislation and internal data management policies. You can configure a retention policy for your backups, and if anyone requests that their data be deleted, you can easily purge their individual records from all backups.
Are you prepared for data loss?
Gearset’s State of Salesforce DevOps report found that 47% of businesses saw at least one data or metadata loss incident in the last year. Businesses are recognizing both the importance of backups for Salesforce and the need for a robust backup solution built specifically for Salesforce so it can handle all the platform’s quirks for migrating data and metadata.
Data Export can be tempting to use for backups, as Salesforce’s native tool for exporting data. But while it’s handy for getting data out of your org, it simply isn’t built for backups and recovery, let alone full backup and restoration for disaster recovery.
Start protecting Salesforce
Hitting the limits of Data Export? Book a demo to learn how Gearset handles backup and restore, and disaster recovery for Salesforce teams.
Download our free backup ebook
Want to know more about backing up Salesforce? Download our free ebook, Backups for Salesforce to get a complete overview of the risks of data and metadata loss — and what options businesses have to mitigate them.
