Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Maintaining your database » Backup and data recovery » The internal backup process » Managing the transaction log

 

The rollback log

As changes are made to the contents of a database, a rollback log is created so that changes can be canceled if a transaction is rolled back or if a transaction is uncommitted when a system failure occurs. There is a separate rollback log for each connection. When a transaction is committed or rolled back, the contents of the rollback log for that connection are deleted. The rollback logs are stored in the database, and rollback log pages are copied into the checkpoint log along with other pages that are changed.

The rollback log is also called the undo log.

For more information about transaction processing, see Using transactions and isolation levels.