I have a legacy database that is corrupted. It has 1000s of duplicate and orphaned files. I’d like to delete the duplicate and orphaned files en masse rather than one at a time. Is this possible?
If you run Verify and Repair, your orphans will be found in an “Orphaned” group, which can be deleted. A smart group can be set up to find all duplicates, then you could select the files in the smart group and delete them. Make sure to empty the trash after.
But … this begs the question: how did your database get into this condition? Orphans are rare – and with good database management practices should not be occur.
Before you do major surgery, be sure to have good backups and export the database to an archive.