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 server-side backup

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

Prerequisites

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

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. Execute a BACKUP DATABASE statement or run the dbbackup utility with the -s option.

Results

The database backup is stored on the database server computer.

Example

Execute the following statement to create a backup copy of the database files in the directory C:\temp\backup on the server computer. 

BACKUP DATABASE DIRECTORY 'C:\\temp\\backup';

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

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

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0