SQL Script to Verify the Database backup file
Here is the SQL Script to be able to Verify the Database Backup file before you want to Restore it. This will let you know if your Backup is fine and usable or Corrupt and not usable.
IF @@ERROR = 0
PRINT 'Your Backup is in a Usable State'
PRINT 'Sorry, Your Backup is corrupt and is not in a Usable State'