Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

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.

Alarm Description

Backup - Days Since Last Full Backup

The Full Backup Alarm is enabled by default. A high alarm is raised if a full backup on this database has never taken place or has not taken place in the last three days.

Backup - Hours Since Last Differential Backup

Differential backups are important for mission-critical databases. The Differential Backup alarm is disabled by default. When enabled, a high alarm is raised if a differential backup on this database has never taken place or has not taken place in the last 24 hours.

Backup - Minutes Since Last Log Backup

Log backups are useful in keeping transaction logs to a reasonable size. The Log Backup alarm is disabled by default. When enabled, a high alarm is raised if a log backup on this database has never taken place or has not taken place in the last 120 minutes.

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating