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).
 See also

Making a server-side backup with the BACKUP DATABASE statement
Making a server-side backup with the Backup utility (dbbackup)
Making an archive backup with the Backup Database Wizard
Creating an image back up (Create Backup Images Wizard)
SQL Anywhere Volume Shadow Copy Service (VSS)