Backup notifications
By default, the backup jobs that are created by the scripts insert a message in the Event Log if the backup job fails to run.
- The reason for the error can be seen by viewing the history of the backup job in SQL Server Management Studio.
- The backup jobs can be configured to send emails on success and failure if the SQL Server Notification Service is installed and enabled. See SQL Server notifications.