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.
You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.
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.
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;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|