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.
See alsoUse 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.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |