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.

Prerequisites

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

 Task

  1. Connect to the database.

  2. Validate the database.

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

Results

The database backup is stored on the client computer.

Example

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
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0