Client-side backups

The following methods are supported for making a client-side backup:

Tool More information
Backup utility (dbbackup) The Backup utility (dbbackup) uses physical device-level parallelism to decrease the overall time required to complete a backup operation. Parallel backups are not supported on Windows Mobile.
DBBackup function See DBBackup method [database tools].
 Make a client-side backup (dbbackup utility)

The dbbackup utility makes an image backup, which consists a copy of the database file and/or the transaction log, each as separate files.

  1. Connect to the database as a user with REMOTE DBA or BACKUP authority.

  2. Run the Backup utility (dbbackup) on the client computer. For example:

    dbbackup -c "HOST=myhost;DBN=demo;UID=DBA;PWD=sql" SQLAnybackup
 See also

Making a live backup