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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery » Backup and recovery internals


Restrictions during backup and recovery

The database server prevents the following operations from being executed while a backup is in progress:

  • Another backup, with the exception of a live backup.
  • A checkpoint, other than the one issued by the backup instruction itself.
  • Any statement that causes a checkpoint. This includes data definition statements, as well as the LOAD TABLE and TRUNCATE TABLE statements.

During recovery, including restoring backups, no action is permitted by other users of the database.