How can we help you today? How can we help you today?

Verifying that a Red Gate Backup had Checksum enabled

Hi,

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?

Thanks

Chris
ChrisAVWood
0

Comments

2 comments

Sort by
  • petey
    The CHECKSUM setting isn't displayed in any of the SQL Backup outputs (RESTORE SQBHEADERONLY, RESTORE HEADERONLY). You would need to check the msdb..backupset table for the relevant backup to confirm that checksums were turned on (the has_backup_checksums column).
    petey
    0
  • ChrisAVWood
    In that case Petey, I would like to make this a request to have this information added to RESTORE SQBHEADERONLY output.

    Thanks

    Chris
    ChrisAVWood
    0

Add comment

Please sign in to leave a comment.