How can you be notified if a native SQL Server database backup or restore fails via the native tools?

Setup SQL Server Alerts to notify SQL Server Agent Operators on a failure condition.
Include RAISERROR or TRY/CATCH logic in your backup or restore code to send an email on a failure condition.

SQL Server ships with native alerts that can be configured to notify an operator when a backup or restore failure occurs.  Reference the chart below for the SQL Server backup and restore alerts as well as the link to the T-SQL code below to implement these alerts.

1287-53-sqlserver.png
Figure 1. 1287-53-sqlserver.png
Need Help? Contact Us.

Log in

*
*

Forgot password?

*

New User

*
*
*
*