My Company is currently at a point where we need to clean up some data to make sure we don't exceed our storage limits.

I've run the numbers and would need to remove ~525,500 tasks to clear out the majority of our data.

These are all older completed tasks.

What would be the easiest way to back these up and remove them from Salesforce?

  • Export and delete using data loader – Eric Aug 15 '16 at 21:42
  • @Eric Can the data loader handle that much? And how can I delete using the Data Loader? – Cody Beaner Aug 15 '16 at 21:44
  • Back it up for historical data, and use data loader – EricSSH Aug 15 '16 at 21:44
  • @CodyBeaner dataloader works in batches of 200 so sure it will work, who knows how long it will take – EricSSH Aug 15 '16 at 21:44
  • @EricSSH - Data Loader in bulk API mode can be very fast. I killed off 150,000 Leads the other day in a reasonable (<1 hr) time – cropredy Aug 16 '16 at 0:18

Using the Salesforce DataLoader will enable you to extract all desired task records with all associated attributes.

Once the extraction step is complete you need only run a delete job against the activity record ids that you extracted in the first step and the job is done.

| improve this answer | |
  • How can I run the delete with no limit issues? Can I do this with the Data Loader? – Cody Beaner Aug 15 '16 at 21:46
  • Should be fine. Run dataloader in bulk api mode, and if you find that there are triggers on task delete that blow your governor limits, reduce the chunk size - both using bulk api mode and chunk size settings are in the settings area of DataLoader. – CloudHugger Aug 15 '16 at 21:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.