This topic describes a backup that leaves the transaction log untouched. For information about other transaction log management options when making a backup, see Backup utility (dbbackup).
The dbbackup utility makes an image backup that consists of a copy of the database file and/or the transaction log, each as separate files.
If you are using the dbbackup utility, use the following syntax:
dbbackup -c "connection-string" [ -t ] backup-directory
Include the -t option only if you are making an incremental backup. See Incremental backups.
The following example makes a backup on the database server computer in the directory c:\SQLAnybackup.
dbbackup -s -c "ENG=sample_server;DBN=demo;UID=DBA;PWD=sql" "c:\SQLAnybackup"
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|