Advantage Database Server

Differential Backups

Advantage Concepts

Differential Backups

Advantage Concepts

Previous topic Next topic  

Differential Backups

Advantage Concepts

Previous topic Next topic  

A differential backup only backs up record data that has changed since the last differential backup was performed. For example, if you have a large database or large tables that cause a slow backup, you could instead initialize a differential backup, and then call all subsequent backups sending the differential option (‘Diff ’). The initial differential backup would perform a complete backup of the data. The subsequent backups would only process tables and records that had been modified since the last backup was performed. This can significantly improve backup performance.

A differential backup should be reinitialized whenever table structure changes are made or when the table is packed or emptied (zapped). In addition, when using sp_BackupFreeTables, you should reinitialize the differential backup if you add, delete, or change any indexes. To initialize or reinitialize a differential backup, run the backup command with the ‘PrepareDiff ’ option.

Differential backups are only supported on Advantage proprietary tables (ADT tables).