We have a database at one of our sites that
cannot restore because there are duplicate records
in primary indices.

Does anyone know how this can happen?

Also how can we automatically clean all these records from
the database so we can backup and restore it.