Creating an image backup (SQL)

Use the BACKUP statement to create an image backup that consists of a copy of the database file and/or the transaction log, each as separate files.

Prerequisites

You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.

Task

Connect to the database.
Validate the database.
Execute the following statement to make an image backup:
BACKUP DATABASE DIRECTORY directory-name;
This backup leaves the transaction log untouched.

Results

The BACKUP statement makes an entry in the text file backup.syb. For information about the location of the backup.syb file, see SALOGDIR environment variable.

Example

The following statement makes an image backup of the current database and the transaction log, saves them to different files, and renames the existing transaction log.

BACKUP DATABASE
DIRECTORY 'c:\\temp\\backup'
TRANSACTION LOG RENAME;

Creating an image backup (SQL)

Task

See also