Using dbtran to Validate the Backup

Validation allows you to check the integrity of incremental backups and to ensure that you can safely apply these increments to the offline backup. This is a vital step and cannot be bypassed, without risking the viability and integrity of your backup data.

Use dbtran to translate the incremental transaction log generated to SQL commands. This utility fails if any data in the log is invalid or corrupted. If the utility succeeds, you can safely apply the log to the full backup on the recovery server.

  1. Validate the transaction log backup by converting it to SQL command file:
    dbtran yymmddxx.log yymmddxx.sql
  2. Delete the resulting yymmddxx.sql file as it is not required for any other purpose.
Parent topic: Performing Periodic Incremental Transaction Log Backups Online
Previous topic: Using dbbackup to Create Incremental Backups