A backup is a full or partial copy of the information in a database, held in a physically separate location. If the database becomes unavailable, you can restore it from the backup. You can use your backups to restore all committed changes to the database up to the time it became unavailable.

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.

If the operating system or database server fails, or the database server does not shut down properly, then the database must be recovered. On database startup, the database server checks whether the database was shut down cleanly at the end of the previous session. If it was not, the database server executes an automatic recovery process to restore all changes up to the most recently committed transaction.

SQL Anywhere tools make online backups that are executed against a running database. You must have BACKUP authority or REMOTE DBA authority to make online backups of a database. You can make offline backups by copying the database files when the database is not running.

 See also