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.
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)