Transaction Recovery - Teradata Database

Two types of automatic transaction recovery can occur:

Single transaction recovery

Database recovery

The following table details what happens when the two automatic recovery mechanisms take place.

This recovery type…	Happens when Teradata Database…
single transaction	aborts a single transaction because of: Transaction deadlock User error User-initiated abort command An inconsistent data table Single transaction recovery uses the transient journal to effect its data restoration.
database	performs a restart for one of the following reasons: Hardware failure Software failure User command