Verifying the integrity of legacy databases by using the checksum option

Edit online

With IBM Storage Protect Snapshot, you can verify the integrity of legacy database backups by setting a checksum option.

About this task
A checksum is a value that is calculated and written in the data page header of the database data file. When a data file is read again, the checksum value is recalculated. Checksum processing validates the values in a file or configuration for unexpected changes. Values are verified between the current state and the baseline state.
Restriction: Checksum integrity checking is available only with legacy backups on SQL Server.
Procedure
  1. Open the General Properties window in Microsoft Management Console (MMC).
  2. Select Compute SQL Server checksum for legacy backup.

    If you select this option, all legacy backups are checked by default. You can override this setting to set integrity checking for a particular backup.

    For example, if you bypassed integrity checking on all backups, you can set integrating checking on a particular legacy backup by selecting the SQL Checksum backup option on the Protect tab for the SQL instance. You can also issue the SQLCHECKSum option with the backup command on the command line to temporarily enable or disable the checksum option.
Results

When you select the Compute SQL Server checksum for legacy backup check box, the setting is written to the IBM Storage Protect Snapshot for SQL Server preferences file, tdpsql.cfg, and is applied to all legacy backup operations. If you clear the check box, integrity checking does not apply to any legacy database backup.

Related tasks