Show TOC

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

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

Prerequisites

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

Procedure

  1. Connect to the database.
  2. Validate the database.
  3. Run the Backup utility (dbbackup) with the -c option on the client computer.

Results

The database backup is stored on the client computer.

Example

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

dbbackup -c "Host=sample_host;SERVER=myserver;DBN=demo;UID=DBA;PWD=sql" "c:\SQLAnybackup"