• *** it happens, I already use CHECKSUM. I also run a DBCC CHECKDB on the database before being backed up ensuring that should that fail that the backup is not done and an alert is raised.

    Hopefully, all these measures will increase the chances of a successful restore should I need it.