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 » Backing up databases


Creating a client-side backup

Back up a database and store the backup files on the client computer.


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

  1. Connect to the database.

  2. Validate the database.

  3. Run the Backup utility (dbbackup) with the -c option on the client computer.


The database backup is stored on the client computer.


Run the following command to create a backup copy of the database files in the directory c:\SQLAnybackup on the client computer.

dbbackup -c "Host=sample_host;SERVER=myserver;DBN=demo;UID=DBA;PWD=sql" "c:\SQLAnybackup"

 See also