FrontBase Documentation

Backtrack:
  Welcome!
    5. SQL 92
      5.4. FrontBase Extensions
Updated: 20-Nov-2000
prev — next
Table of Contents

5.4.6. Backup

WRITE DATA [WITH TRANSACTION DATA];

This initiates a backup of a live database. Once this statement has completed its execution without errors, the backup is done. The backup will be written to the file:

FrontBase/Backups/<database name>/B_<yymmdd>_<hhmmss>

The backup will latch onto the newest possible version of the database. Specify the WITH TRANSACTION DATA option to ensure that a rollforward (in connection with a restore operation) including ongoing transactions can succeed.

DROP TRANSACTION DATA;

Drops the generation of transaction data (as initiated by e.g. WRITE DATA WITH TRANSACTION DATA). This will limit how close to the current state of a database a rollforward action can achieve.

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!