This alert will detect databases that have not had a backup done within the last day. It will provide a simple count, and any return of 1 or more (at least one backup for a database has failed) will trigger an email.
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert with values similar to these:
Alert Name: Missing backups
Execution Interval: 1 day
Notification Text: This instance has databases not backed up in the last day.
Active Database Instances: Add the Ignite Repository DB only
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.