This script is used to verify a backup chain. It is based on Robert Davis’ script. It gets the most recent full backup, the most recent differential backup based upon that full, and then all transaction log backups since the latter of those two backups. It calculates whether there is a broken transaction log chain, and also whether the backup files are in the location where they were backed up to.