We help IT Professionals succeed at work.

SQL Server 2008 alerts

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.
Comment
Watch Question

Top Expert 2011

Commented:
The way I did mine, I would guess the same would work for you, is to set up an alert under SQL Agent in SSMS explorer window.

if you right-click on alerts and select New Alert, follow the on-screen instructions to set it up.

Point the alert to any job you may have already created, the database and then on the last screen is the options you have, one of which is Email notitification.

Commented:
The alertId is 3041. Provide that and go through the GUI. Its pretty much simple.
SQL Server DBA
Top Expert 2011
Commented:
Drag the Notify operator from tool box of maintenance plan, here you can configure the notification in the event of  failure or success of your steps in maintenance plan.

 Screenshot

Author

Commented:
Thank you Anujab. I will try this.

One last question. THe application vendor that uses this SQL Server instance, specifed that there is a specific order that the databases must be backed up in. I'm thinking that I'll need to recreate my backup maintenance plan and add a sub-task for each database in the order that is required.

Should I add the Notify Operator task after each database backup subtask, or just one at the end? What is the best-practice for this?

THanks!

Bits

Author

Commented:
I only want to  be notified upon failure. Will this work?

mimosa-2.bmp

Author

Commented:
It was complete.