Server-side backups

Making a backup on the database server computer is generally faster than a backup on a client computer because the data does not have to be transported across the client/server communications system. To build a server-side backup into your application, use a SQL statement. The following methods are supported for making a server-side backup:

Tool	More information
BACKUP statement	The BACKUP DATABASE statement uses physical device-level parallelism to decrease the time required to complete a backup operation. Parallel backups are not supported on Windows Mobile. See Parallel database backups.
Backup utility (dbbackup)	The Backup utility (dbbackup) uses physical device-level parallelism to decrease the time required to complete a backup operation. Parallel backups are not supported on Windows Mobile. See Parallel database backups. See Creating a server-side backup with the Backup utility (dbbackup).
Backup Database Wizard	This wizard creates an archive backup. You can specify a file name or tape drive where the backup is stored. See Creating an archive backup (Sybase Central).
Create Backup Images Wizard	This wizard creates a copy of each database file while the database is running. To recover, you copy all the files back in place on the database server computer. See Creating an image backup (Sybase Central).
Create Maintenance Plan Wizard	This wizard lets you create a schedule for a variety of tasks, including backing up the database. You can choose to create an archive, a file image, or an incremental backup. See Maintenance plans.
DBBackup function	See DBBackup method [database tools].
SQL Anywhere Volume Shadow Copy Service (dbvss)	See SQL Anywhere Volume Shadow Copy Service (VSS).

If disk sandboxing is enabled for the database, you must specify the secure feature key for the database server to be able to make the backup in a directory outside of the sandbox (the directory where the main database file is located and any subdirectories of this directory).

Server-side backups

See also