• This answer is wrong. Just because SQL does not actually perform the backup, doesn't mean it won't store information about the RESTORE command. In that table, there's a restore_type that could be verifyonly:

    restore_type

    char(1)

    Type of restore operation:

    D = Database

    F = File

    G = Filegroup

    I = Differential

    L = Log

    V = Verifyonly

    R = Revert

    Can be NULL.