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
Configuration
Backup alarms can be configured for your environment. For more information, see Configure | Alarms.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy