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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Server-side backups


Making a server-side backup with the Backup utility (dbbackup)

 Make a backup, continuing to use the original transaction log (command line)

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

This topic describes a backup that leaves the transaction log untouched. For information about other transaction log management options when making a backup, see Backup utility (dbbackup).

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

  2. If you are using the dbbackup utility, use the following syntax:

    dbbackup -s -c "connection-string" [ -t ] backup-directory

    The -s option creates an image backup on the database server.

    Include the -t option only if you are making an incremental backup.

 See also