Does LiteSpeed check page level checksums when restoring or verifying? (4240822)

The SQL Server 2005 Books Online article Detecting and Coping with Media Errors says:

If backup checksums are present on the backup media, by default, both the RESTORE and RESTORE VERIFYONLY operations verify the backup checksums and page checksums.

Does LiteSpeed 5 check page checksums when restoring or verifying?

RESOLUTION

xp_backup_database accepts the undocumented @with parameter checksum, which will cause SQL Server page level checksums to be verified as a backup is created.

xp_restore_verifyonly does not take the @with parameter checksum, but if the backup was taken with checksum then by default, the procedure will test for checksum.

xp_restore_database accepts the @with=checksum parameter. If this parameter is not explicitly set and the backup file has checksum, the procedure, by default, will still test for checksum.

STATUS

Enhancement requests ST68071 and ST68104 have been submitted to Development for consideration in a future release of LiteSpeed for SQL Server.

ST68071 is to update the LiteSpeed help file on the @with=CHECKSUM parameter.

ST68104 is to fix the issue in the LiteSpeed GUI Backup Wizard where the Perform checksum before writing to media option is only enabled when performing a native backup (that is unchecking the Use LiteSpeed option). The checksum option should also be available during a LiteSpeed backup.

To learn more about SQL Server CHECKSUM, please refer to Detecting and Coping with Media Errors http://msdn.microsoft.com/en-us/library/ms189055(SQL.90).aspx