Configure SQL Backup Health Probe

The SQL Backup health probe returns the amount of time elapsed since the last backup of the specified Microsoft SQL Server database. If the database has never been backed up it returns N/A.

Settings

Server – The name of the database server. May include an instance name. e.g. MIMPRD01\SQL

Database – Which database to check for backup, e.g. FIMSynchronizationService

User & Password – Optional user credentials

Fail Rule – The default fail rule converts the result to a Time span and fails if more than one week has elapsed since the last backup.

CoerceTimeSpan(Value) > Days(7)