Thanks for the responses

I currently do weekly full and daily differential backups in addition to the transaction log backups. Currently I tend to investigate the alert method with a transactional...