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

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


Types of backup

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

Backup type Description More information
Online A backup that is performed while the database is running. See Online and offline backups.
Offline A backup that is performed when the database is not running. This type of backup should only be performed when the database server has shut down properly. See Online and offline backups.
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. Incremental backups
Live A continuous 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. Image backups
Server-side A backup made on the database server computer. Making a server-side backup
Client-side A backup made on the client computer. Making a client-side backup

Online and offline backups
Full backups
Incremental backups
Live backups