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.
Prérequis
You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.
Contexte et remarques
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.
Exemple
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" |
![]() |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |