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 » Types of backup


Full backups

A full backup is a backup of both the database file and the transaction log. You must have BACKUP or REMOTE DBA authority to perform a full backup.

 To make a full backup (overview)
  1. Perform a validity check on your database to ensure that it is not corrupt. You can use the Validation utility or the sa_validate stored procedure. See Validate a database.

  2. Make a backup of your database file and transaction log.

    For information about how to perform the backup operation, see:

The simplest form of backup is an image backup (which consists of a copy of the database file and/or the transaction log, each as separate files) that makes copies of the database file and transaction log, and leaves the transaction log in place without truncating or replacing it. All backups leave the database file in place. A full backup of this kind is illustrated in the following figure.

In a full backup, the database file and log file are copied to the backup directory. The backup leaves the database file and log file in place.
 See also