Is there a way to setup an alert on scheduled log file backup if it fails?

by Feb 17, 2022

Currently, I have used SQL Agent to perform a log backup every 15 minutes on a database in 'Full' backup mode.

The log backup process writes to a local drive, and also to a network drive in parallel.  It came to us that if the network drive becomes unavailable, the log backup process will just fail even the local drive destination is ok.

The failed message will only be found in the SQL error log, I wonder if I could configure SQL Diagnostic to send out an alert if it  happens.

Thank you.