• It appears they were attempting to truncate the log on a failed script they wrote.

    Is there a way to query SQL Server to verify all the log backups are available to a for recently performed full backup? For example, if someone was to run an adhoc log backup to an unknown location, it appears there is no way to know that there was a missing log file.