Back up a database and store the backup files on the database server computer.
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).
Connect to the database.
Validate the database.
Execute a BACKUP DATABASE statement or run the dbbackup utility with the -s option.
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"
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|