Restituisci
-
Titolo
Many "DBSS - Days Since Last Backup" alarms are fired -
Descrizione
Customer has received over fifty warning alarms for "DBSS - Days Since Last Backup" in SQL Server agents
-
Causa
The Days Since Last Backup alarm fires alarms for all of the databases from the instance that the agent monitors by design. -
Risoluzione
Users can exclude individual databases for each database agent by editing the agent configuration in the Administration panel and adding the names of databases that should be excluded from the alarm.
NOTE: Backup alarms not to be fired for the following database statuses/types:
- Database is in status RESTORING or OFFLINE or MIRROR
- Database is read_only
- Database is in_standby
- Database is a snapshot
- Database is part of an availability group and the current replica is not set as preferred replica for backup
- Database is in Azure SQL Managed Instance