Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Backup and Data Recovery » Designing backup procedures » Making image backups

Making image backups Next Page

Understanding parallel database backups


When you perform a server-side image backup using the Backup utility (dbbackup) or the BACKUP DATABASE statement, a parallel database backup is performed. Parallel backups use physical device-level parallelism to decrease the overall time required to complete a backup operation. Parallel backups are not supported on Windows CE.

The database server creates a reader thread for each drive on which database files are stored. A writer thread is created for the destination drive where the backup directory is located. Using separate readers and writers allows I/O operations to be performed in parallel, instead of sequentially.

The performance of a parallel backup is limited by the slowest component in the system. In most cases, the bottleneck is likely a physical disk, but it could also be any of the other components, such as the I/O controller or the system bus. Each of these components has a maximum rate at which they can transfer data.

The BACKUP DATABASE statement and the Backup utility (dbbackup) provide options that let you configure the behavior of a parallel backup, including:

Backups should always be made to a separate physical drive. This not only provides a performance benefit from the I/O parallelism, but also improves the safety of the data in the event of a hardware failure.

See also