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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Types of backup


Full backups

 Make a full backup (overview)

A full backup backs up both the database file and the transaction log.

You must have BACKUP or REMOTE DBA authority to perform a full backup.

  1. Connect to the database as a user with REMOTE DBA or BACKUP authority.

  2. 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.

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


    The backup copies of the database file and transaction log file have the same names as the online versions of these files. For example, if you make a backup of the sample database, the backup copies are called demo.db and demo.log. When you repeat the backup statement, choose a new backup directory to avoid overwriting the backup copies

 See also