To do a full database restore, you load the most recent full dump file and then apply, in sequential order, all the incremental backups that were generated after the dump. This process enables you to restore the database to its state up to the last transaction recorded in the binary logs.

Binary Log File Names

Each binary log is assigned the following file name:

• stadb-bin.nnnnnn

where:

• nnnnnn is a unique number indicating the sequence in which the incremental backups were created.

For example, stadb-bin.000034, stadb-bin.000035, and stadb-bin.000036 could be three successive incremental backups created by the STA Backup service.

Binary Log Locations

All incremental backups created since the last full backup are located in the /var/log/tbi/db directory on the STA server. The number of binary log files in the directory depends on the incremental backup interval you have specified.

The Backup Service removes all incremental backups from the /var/log/tbi/db directory when it completes a daily full backup. Therefore this directory only contains incremental backup files created since the last full backup. You should never delete binary log files from this directory yourself.

• If you are not doing remote backups, the incremental backups are deleted from this directory and not retained anywhere.
• If you are doing remote backups, the incremental backups are transferred to the remote backup directory every 24 hours, when the compressed full database dump files are moved. You can keep as many days worth of incremental backups on the backup server as your site's policies require.

See Also:

• Define the Incremental Backup Interval
• List Incremental Backup Files (Binary Logs)
• View Binary Log Contents