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.
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).
Connect to the database.
Validate the database.
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.
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"
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|