The check sum feature can be used to verify that the backup file is not corrupted. This feature does not validate that the backup set is valid, but provides you with a check sum value to validate the files.
The checksum feature is available in all versions of LiteSpeed.
There are two ways to obtain a check sum value for a file:
1. Via SQL Server's Query Analyzer using xp_restore_checksumonly extended stored procedure.
2. Via SQL LiteSpeed's command line. To execute, navigate to the directory
c:program filesimcedalitespeedsql serverengine in the command prompt. You can also issue a command on LiteSpeed's command line (-R checksumonly).
Syntax:
EXEC master.dbo.xp_restore_checksumonly
@filename = 'backup_file_name'
