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. See Making a server-side backup with the BACKUP DATABASE statement.
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 Making 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 Making an archive backup with the Backup Database Wizard.
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 back up (Create Backup Images Wizard).
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 plan creation.
DBBackup function	See DBBackup method [database tools].
SQL Anywhere Volume Shadow Copy Service (dbvss)	See SQL Anywhere Volume Shadow Copy Service (VSS).

Server-side backups

See also