The backup journal is used to make following up and verifying database backups easier. The backup module writes a summary of all the operations it performs: backups, restores, integrating log file etc.
These operations are logged in this file with the date and time when the operation occurred, regardless of whether they were scheduled or done manually. The backup journal is named "Backup Journal.txt" and is stored next to the database data file.
In the instance of a backup, the journal notes the following information:
For each archive:
- Access path (for the archive or the created or deleted log)
- Archive contents (data file, structure file, user structure file, index files, log file)
For each item in the archive:
- File type
- Original file size
- Date/Time (starting time, scheduled time, ending time)