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