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
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |