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.

To make a backup, continuing to use the original transaction log (command line)

• 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.

Example

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"

See also

• Image backups
• Restore from an image backup
• Recovering your database