Backing Up and Restoring Databases
Page 3 of 4

Backup History

Backup history is stored in an ASCII file (BACKUP.HISTORY) in the database directory of the original database (not its backup). This file records the time and location of the backup. If the file does not already exist, it is created during the backup. If it does already exist, new information is appended to it.

Thu Sep 09 09:18:35 PDT 1999:Backup started for database located at D:\mydatabases\toursDB
Thu Sep 09 09:18:44 PDT 1999:copied database directory from D:\mydatabases\toursDB to C:\mybackups\1999-01-01\toursDB
Thu Sep 09 09:18:44 PDT 1999:copied log directory from D:\mydatabases\toursDB\log to C:\mybackups\1999-01-01\toursDB\log
Thu Sep 09 09:18:44 PDT 1999:Backup completed, log instant at (10,15855)

Failure Recovery

Regardless of which backup option you choose, if a backup does not complete, the newly created copy of the database is unusable. There is no automatic cleanup for backup failure.

If the database crashes during a backup or freeze, the original database is "normal" after it is recovered, and the copy is unusable and should be discarded.