IMPAX 6.5.1 Server Knowledge Base home > SQL Server home

Restoring the SQL databases when differential or incremental backup jobs are enabled


If your system suffers from a database crash and you have enabled the differential or incremental backup jobs, you must follow a different procedure to recover your database.

CAUTION!

CAUTION!

Ensure that you always have a complete backup before you enable any differential or incremental backups.

To recover from a complete and differential backup

  1. Perform a recovery using the data from each of these backups in the following order:

    • The most recent complete backup

    • The most recent differential backup

    • The log backup after the crash

To recover from a complete, differential, and incremental backup

  1. Perform a recovery using the data from each of these backups in the following order:

    • The most recent complete backup

    • The most recent differential backup

    • Ordered log backup (from earliest to latest) after the differential backup

    • Log backup after crash


Topic number: 8844

Applies to: IMPAX 6.5.1 Server Knowledge Base