Show TOC

Creating a Server-Side BackupLocate this document in the navigation structure

Back up a database and store the backup files on the database server computer.

Prerequisites

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

Procedure

  1. Connect to the database.
  2. Validate the database.
  3. Execute a BACKUP DATABASE statement or run the dbbackup utility with the -s option.

Results

The database backup is stored on the database server computer.

Example

Execute the following statement to create a backup copy of the database files in the directory C:\temp\backup on the server computer.

BACKUP DATABASE DIRECTORY 'C:\\temp\\backup';

Run the following command to create a backup copy of the database files in the directory c:\SQLAnybackup on the server computer.

dbbackup -s -c "DBN=demo;UID=DBA;PWD=sql" "c:\\temp\\SQLAnybackup"