In a migration where 200,000 case records were imported incorrectly and the most recent backup is over 90 days old, what is the recommended action?

• A. Use Data Loader to delete the corrupt data.
• B. Manually update the corrupt data to correct it.
• C. Restore the data using the available backup.
• D. Log a Data Recovery case with Salesforce Support.

Answer: (B)

When data was imported incorrectly and the latest backup is from a long time ago, the safest way to fix is to correct the data in place rather than revert to a backup. Restoring from an old backup would roll the entire system back by 90 days, discarding many legitimate changes and potentially creating new inconsistencies. If you can identify exactly what was wrong and what the correct values should be, you can repair the records directly by updating the corrupted fields in bulk. Use a reliable, controlled process (for example, a Data Loader update using a unique identifier to locate each record) and validate results in a sandbox or with small batches before applying to production. This approach preserves the current state of all other data and minimizes data loss.

Deleting the records would remove data you’ll need again, and relying on a Data Recovery case with Salesforce Support is reserved for catastrophic data loss scenarios rather than routine data quality fixes.