Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Backup Alarms

A Backup Alarm is raised when Spotlight on SQL Server detects that a backup on the SQL Server database has never taken place or has not taken place in the designated time frame.

When the alarm is raised

• Check the date and time of the last backup from the SQL Server | Databases Drilldown | Databases grid. You may need to set the Database View to Backup Status.
• Ensure you have appropriate backups of all necessary databases.

Configuration

Backup alarms can be configured for your environment. For more information, see Configure | Alarms.

• By default the alarm is cleared once the time frame since the last backup falls within the designated time frame. Alternatively, to maintain the alarmed status until the alarm is acknowledged, select Alarm requires acknowledgment in the Configure Alarms dialog.
• Some databases may be more critical to your organization than others. Configure the severity of the alarm raised to depend on the database the alarm is raised against. For more information, see Configure an alarm.
• Customize the designated time frame. For the Backup - Days Since Last Full Backup Alarm, by default 0 to 3 days is Normal. A High severity alarm is raised after 3 days. Click in the Alarms Dialog | Severity Table to edit the values. Decimal values can be used to indicate portions of a day. For example you could edit the table to raise a high severity alarm after 3.5 (3 and a half) days or 3.25 (3 and a quarter) days.
• Some databases are never backed up. Exclude certain databases from this alarm. See Do not alarm for certain values for more information.