SQL Verify

Test the specified backup for validity.

For an overview see page Incremental_Backup

The statement has the following form:

 
    VERIFY FILE file_name LABEL label [WITH CIPHER=key]
     

Description

This function tests the specified backup for validity by reading the backup records one at a time and checking the CRC of all records. It does the same as the RESTORE operation but without modifying the existing database.

Example

 
    VERIFY 'SimpleDb_backup' LABEL 'Backup July 15, 2016'
 

Note that if this statement is executed by a remote client, the backup file name refers to the server's file system.