CREATE JOURNAL ARCHIVE

Go Up to Statement and Function Reference (Language Reference Guide)

Activities journal archiving and performs the initial database dump to the archive directory.

CREATE JOURNAL ARCHIVE <journal archive directory>

Argument

Description

journal archive directory

The location in which InterBase stores the journal archive. If the directory does not exist or is not accessible, InterBase returns an error message. The directory path can be a local drive, a mapped drive, or an UNC path (as long as the underlying file APIs can open the file using that specification). If you do not specify a journal archive directory in the CREATE JOURNAL ARCHIVE statement, InterBase uses the journal directory created with the CREATE JOURNAL statement.

Description: The CREATE JOURNAL ARCHIVE command performs two functions: it activates journal archiving in an InterBase database, and it automatically performs the initial full, physical dump of the database. InterBase stores the dump in the journal archive directory you specify in the CREATE statement. A journal archive enables you to recover to the last committed transaction in the most recently archived and completed journal file.

Important: CREATE JOURNAL ARCHIVE creates the archive and performs an initial dump. However, you must issue a specific gbak command to copy completed journal files to the journal archive. You use another gbak command to perform subsquent dumps to the archive. For information about the gbak archive commands, and about how to implement journaling and journal archiving, see the InterBase Operations Guide.

Topics

• Journal Archive Management

See Also

• DROP JOURNAL ARCHIVE
• CREATE JOURNAL
• DROP JOURNAL