Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Types of backup

 

Creating a full backup

Run a full backup to back up both the database file and the transaction log.

Prérequis

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

Contexte et remarques

The backup copies of the database file and transaction log file have the same names as the online versions of these files. For example, if you make a backup of the sample database, the backup copies are called demo.db and demo.log. When you repeat the backup statement, choose a new backup directory to avoid overwriting the backup copies.

 Task
  1. Connect to the database.

  2. Validate the database to ensure that it is not corrupt. You can use the Validation utility, the sa_validate stored procedure, or the VALIDATE DATABASE statement.

  3. Make a backup of your database file and the transaction log. For example, use the BACKUP statement.

Résultat

A full backup of your database file and the transaction log is created.

Exemple

The following statement creates a full backup of the database in the directory C:\temp\backup:

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

 See also