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 » Types of backup


Online and offline backups

An offline backup is a copy of the database files. You should only perform an offline backup when the database is not running, and when the database server has shut down properly.

All of the tools included with SQL Anywhere, such as the Backup Database utility (dbbackup), BACKUP DATABASE statement, and Sybase Central wizards, perform online backups while the database is running.

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.

See also