Recovery of temporal tables with system-period data versioning

You must recover a system-period temporal table that is defined with system-period data versioning and its corresponding history table, as a set, to a single point in time. You can recover the table spaces individually only if you specify the VERIFYSET NO option in the RECOVER utility statement.

If you specify TOCOPY, TOLASTCOPY, or TOLASTFULLCOPY in the RECOVER utility statement, you cannot explicitly specify the VERIFYSET option. However, in this case, VERIFYSET NO is the default.

If you recover a system-period temporal table with system-period data versioning to a point in time before the table was altered to have system-period data versioning, the table is still defined with system-period data versioning, but the history table is empty.