I have some records that hold tif files, the beginning tif file is corrupted on some of the records. Should I delete the bad tif and keep that record or should I create a whole new record?

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.