The command that Activates Journal Archiving

From InterBase
Jump to: navigation, search

Go Up to Using Journal Archiving


The CREATE JOURNAL ARCHIVE command activates journal archiving in an InterBase database. A journal archive file (IB_JOURNAL_ARCHIVE) is placed in the journal archive directory.

Note: To perform an initial (and subsequent) dumps, gbak -archive_database must be performed.

The following command is used to activate journaling:

CREATE JOURNAL ARCHIVE <journal archive directory>

where <journal archive directory> is 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.

When you do not activate journal archiving, the current journal files are reused after a checkpoint writes the records of a jounal file to the hard drive.

Important: You only use the CREATE JOURNAL ARCHIVE command to initiate journal archiving on a database. Once you initiate archiving and InterBase performs the first dump, you use the gbak -archive_database command, discussed below, to perform subsequent dumps. If you disable journal archiving and want to resume it, use CREATE JOURNAL ARCHIVE.