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.

Prerequisites

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

Context and remarks

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).

 Task
  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.

Results

The server-side backup is created.

Example

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