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:

• Use the Backup Database Wizard
• Use the BACKUP DATABASE statement to make a server-side backup
• Types of backup