One of the challenges of backup and recovery is manifested when faced with the task of recovering a database or set of databases to a specific point before a critical event occurs. More specifically, the data is considered valid prior to a specific event that caused inconsistencies or data loss. For example, the event could be the result of operator error, a software defect, or hardware/connectivity issues.
When this happens, systems administrators (or database administrators) must restore the data with the last known ...