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 | Use the BACKUP DATABASE statement to make a server-side backup |
Backup utility (dbbackup) | Use the Backup utility (dbbackup) to make a server-side backup |
Backup Database Wizard | Using Sybase Central to make a server-side backup |
Create Backup Images Wizard | Using Sybase Central to make a server-side backup |
Create Maintenance Plan Wizard | Using Sybase Central to make a server-side backup |
DBBackup function | a_backup_db structure |
SQL Anywhere Volume Shadow Copy Service (dbvss) | Using the SQL Anywhere Volume Shadow Copy Service (VSS) |
Both the Backup utility (dbbackup) and BACKUP DATABASE statement use physical device-level parallelism to decrease the time required to complete a backup operation. Parallel backups are not supported on Windows Mobile. See Understanding parallel database backups.
Use the BACKUP DATABASE statement to make a server-side backup
Use the Backup utility (dbbackup) to make a server-side backup
Using Sybase Central to make a server-side backup
Using the SQL Anywhere Volume Shadow Copy Service (VSS)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |