BACKUP statement
402
There can be only one backup on a given tape. The file
backup.syb
records
the BACKUP and RESTORE operations that have been performed on a
given server.
The tape is ejected at the end of the backup.
Archive backup is not supported on the Windows 95/98 operating system.
Archive backups to disk are supported by all versions of NetWare, but
archive backups to tape are not supported on versions of NetWare earlier
than NetWare 5.
Only one archive per tape is allowed, but a single archive can span multiple
tapes.
To restore a database from an archive backup, use the RESTORE statement.
backup-directory The target location on disk for those files, relative to
the server’s current directory at startup. If the directory does not already
exist, it is created. Specifying an empty string as a directory allows you to
rename or truncate the log without making a copy of it first.
WAIT BEFORE START clause This clause ensures that the backup copy
of the database does not contain any information required for recovery. In
particular, it ensures that the rollback log for each connection is empty.
If a backup is carried out using this clause, you can start the backup copy of
the database in read-only mode and validate it. By enabling validation of the
backup database, the customer can avoid making an additional copy of the
database.
MATCH keyword If you supply the MATCH keyword, the backup copy
of the transaction log is given a name of the form
YYMMDDnn.log
. This
enables the same statement to be executed several times without writing over
old data.
archive-root The file name or tape drive device name for the archive file.
To back up to tape, you must specify the device name of the tape drive. For
example, on Windows NT or NetWare, the first tape drive is
\\.\tape0
.
The ’\’ is an escape character in SQL strings, so each backslash must be
doubled. For more information on escape characters and strings, see
"Strings" on page 224.
WITH COMMENT Record a comment in the archive file and in the backup
history file.
Parameters
To Next Page
Loading...