I didn't see any previous solutions that fit my question. I need some advice on setting up alerts in the event that SQL Server Database backups fail.
I've gotten my maintenance plans for doing backups, on a new server and they are scheduled to run. I've also got Database Mail set up and working. But I have some confusion about how to get notifications emailed to me in the event that the maintenance plan for the backups fail.
I've read about setting up an alert, but how do I tie the alert to the backup maintenance plan?
I need step-by-step instructions for this since I'm a newbie to SQL Server.