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

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

Backup quick start
Types of backup
Choosing a backup format
Backup and recovery restrictions
Making a server-side backup
Making a client-side backup
Validating backups
Recovering your database
Designing a backup and recovery plan
Backing up databases involved in synchronization and replication
The internal backup process