Verifying that a Red Gate Backup had Checksum enabled
I have a need to run an SQLBackup with the CHECKSUM option enabled. In a test it didn't seem to take much longer to run than a full backup without the checksum option. I then tested running the T-SQL in the query window of SQL2005 SSMS and the checksum option is not displayed in the output. I then tried using the RESTORE SQBHEADERONLY on the backup file and it does not show any mention of checksum.
Is there a way, in 5.4, to see whether a backup had Checksum turned on?