Data backup in salesforce
I need to develop an Apex script to backup all the database data every day. Is there an optimal way to do that? What could be needed to be done if pictures or pdf files are saved in the database?
Thanks in Advance
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
Daily full backups would be impractical/impossible for anything other than the smallest of organizations, mostly because there's a asynchronous call/day limit, plus all the other governor limits. Your best option would probably be to to use the Data Replication API to perform incremental backups from an external system. The replication API also makes sure that you don't miss any deletions, if that's important. Keep in mind that you can also perform a Weekly or Monthly export in the higher editions of salesforce. Those backups can be full backups, including all files and documents hosted in salesforce.