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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Server-side backups


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

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


You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.

Contexte et remarques

If disk sandboxing is enabled for the database, you must specify the secure feature key for the database server to be able to make the backup in a directory outside of the sandbox (the directory where the main database file is located and any subdirectories of this directory).

  1. Connect to the database.

  2. Validate the database.

  3. Run the dbbackup utility.

    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.

    This backup leaves the transaction log untouched.


The server-side backup is created.


The following example makes an image backup on the database server computer in the directory c:\SQLAnybackup.

dbbackup -s -c "HOST=myhost;DBN=demo;UID=DBA;PWD=sql" "c:\SQLAnybackup"

 See also