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.

RESTORE VERIFYONLY
FROM DISK='C:\YourDatabase.bak'

GO

IF @@ERROR = 0
BEGIN
PRINT 'Your Backup is in a Usable State'
END
ELSE
BEGIN
PRINT 'Sorry, Your Backup is corrupt and is not in a Usable State'
END
GO