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

An offline backup is a copy of the database files. You can make offline backups by copying the database files when the database is not running. You should only perform an offline backup when the database is not running, and when the database server has shut down properly.

An online backup is performed against a running database. Backing up a running database provides a snapshot of the database where the data is in a consistent state, even though other users are modifying the database. You must have BACKUP authority or REMOTE DBA authority to make online backups of a database.

The following table summarizes the types of online backup supported by SQL Anywhere:

Backup type Description More information
Full A full backup is a backup of the database files and the transaction log. Typically, full backups are interspersed with several incremental backups. Full backups
Incremental A backup of the transaction log only. You must run a full backup before running an incremental back up. Incremental backups
Live A continuous backup is a backup of the database that runs while the database is running. Live backups
Archive A collection of one or more files that together contain all the required information for the backup, including the main database file, the transaction log, and any additional dbspaces. Archive backups
Image A copy of the database file and/or the transaction log, each as separate files. On Windows Mobile, only image backups are permitted. Image backups
Server-side A backup made on the database server computer. Server-side backups
Client-side A backup made on the client computer. Client-side backups

Full backups
Incremental backups
Live backups