Versions Compared

Old Version 17

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 18

changes.mady.by.user Alejandra Barrientos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Days since last backup alert applies to any database at the instance level.

Note
titleImportant

The Days since last backup alert is enabled by default.

...

  1. Right-click a SQL Server instance in the Servers tree.
  2. Select Configure Alerts.
  3. Select the Days since last backup metric in the Alert Configuration window.
  4. Click Edit to modify the default threshold (number of days). 
  5. Check the boxes next to Informational, Warning, and Critical to include alerts for these states.
  6. Change the alert thresholds by moving the arrows to the appropriate levels or by double-clicking the value and typing a new threshold level.
  7. Click Advanced to apply advanced settings such as alert suppression or alert filters (excluding a database from alerts or/and Availability Group Collection).
  8. Click OK to accept your changes.

...

To configure a per-database alert:

  1. Right-click a the SQL Server instance in the Servers tree.
  2. Select Configure Alerts.
  3. Select the Days since last backup metric in the Alert Configuration window.
  4. If the metric features a per-database, on the Configuration tab of the Alert Configuration window, click Add. Use the drop-down list to select the database to which you want to apply these settings.
  5. Check the boxes next to Informational, Warning, and Critical to include alerts for these states.
  6. Change the alert thresholds by moving the arrows to the appropriate levels or by double-clicking the value and typing a new threshold level.
  7. Click Advanced to apply the alert suppression.
  8. Click OK to accept your changes.

...

  • Primary
  • Secondary
  • Default
  • Both

And under Under the Replica Collections Options

...

  • When primary and (any or all) other secondary servers are being monitored: Primary The primary server displays the last backup date alert by checking all other secondary servers for the latest backup date of that database. If the latest backup date across that Availability Groups justifies the alert, it displays. The secondary monitored databases also display the same alert, as the latest backup date for an Availability Group across all replicas will be the same.
  • When only primary replica of a database is being monitored: In this scenario the alert displays after SQLDM checks the latest backup date across all replicas and if that date justifies the displayed alert.
  • When some secondary replica is being monitored but no primary replica: In this scenario, the alert displays after SQLDM checks the latest backup date across all replicas and if that date justifies the displayed alert.
Notewarning
titleLimitations
  • The Days since last backup alert does not work for unreadable databases.
  • The assumption is that the connection credentials of all the replicas are the same. At this point SQLDM stores connection credentials only of the monitored servers. If a secondary replica is not monitored, the connection credentials are unknown. This setting can not be included in the properties as a number of some secondary replicas because it is not limited and also its is db specific.
  • A replica may have the latest backup date, but it is possible that the sync is broken between replicas, in which case the db would have been backed up but the some same data would not be there. In this case, the alert may not come if the last back update does not justify an alert.

...