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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Backup and Data Recovery » Configuring your database for data protection

Protecting against total computer failure Next Page

Differences between live backups and transaction log mirrors


Both a live backup and a transaction log mirror to provide a secondary copy of the transaction log. However, there are several differences between using a live backup and using a transaction log mirror:

Live backups and regular backups

The live backup of the transaction log is always the same length or shorter than the active transaction log. When a live backup is running, and another backup restarts the transaction log (dbbackup -r or dbbackup -x), the live backup automatically truncates the live backup log and restarts the live backup at the beginning of the new transaction log. See Making a live backup.