well how important were the .tif files? if there's any way you can salvage them (i.e. open as raw in photoshop, mess with offsets/channels etc. to get a good version) i'd do that - file corruption is pretty rare these days.
if you have a bad file, i see no reason to retain a link to it apart from auditing concerns. if there's no bookkeeping reason to keep the link around, delete the record and create a new one with an updated and valid .tif.