in reply to Log changes in a database (DBI)

restore the DB to a given point in the pipeline
That's what a transaction log is for.