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 » Choosing a backup format

 

Archive backups

An archive backup is 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. You can only perform archive backups as server-side backups. You can save an archive backup to either a file or a tape drive. Archive backups can be made using the BACKUP DATABASE statement or the Backup Database Wizard in Sybase Central.

When making archive backups, an extension is added to the file name you specify in the BACKUP statement for each file that is created (.1, .2, .3, and so on).

You restore a database from an archive backup using the Restore Database Wizard in Sybase Central or using the RESTORE DATABASE statement.

Archive backups are supported on Windows and Unix platforms only. On Windows Mobile, only image backups are permitted. See Image backups.

For information about making an archive backup, see: