Non-copy-only snapshot backups are taken

Comments are closed
How can we help?
< All Topics
Print

Non-copy-only snapshot backups are taken

When taking a backup, the backup chain will be broken if not using the copy-only option. If the backup chain is broken, point-in-time restores can not be performed.

To query the Performance Store database for servers where a snapshot backup is performed within the last week not using the copy-only option, use:

select s.*
from dbo.v_servers s
where 1 = 1
and s.snapshot_non_copy_only_backups = 1

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents