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|
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|