Show TOC

Server-Side BackupsLocate this document in the navigation structure

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.
Backup utility (dbbackup) The Backup utility (dbbackup) uses physical device-level parallelism to decrease the time required to complete a backup operation.

In this section:
    Creating an Archive Backup (SQL)
    An archive backup is a collection of one or more files that together contain all the required information for the backup, including the main database file, transaction logs, and dbspaces. Archive backups can only be performed as server-side backups, and can be saved to either a file or tape drive.
    Creating an Image Backup (SQL)
    Use the BACKUP statement to create an image backup that consists of a copy of the database file and/or the transaction log, each as separate files.