Spotlight is raising alarm for the databases that have had full backups: "A full backup has never been taken for database" (230097)

Chat now with support

Return

Feedback Submitted

Was this article helpful?

Select Rating

Title

Spotlight is raising alarm for the databases that have had full backups: "A full backup has never been taken for database"
Description

Spotlight is raising the Full Backup Alarm for the databases that have had full backups:
"A full backup has never been taken for database"
Cause

Spotlight determines the last backup time from the information saved on msdb.dbo.backupset. If databases were backed up using a tool that doesn’t update this table or somehow deleted the information, then Spotlight will assume no backup took place.
Resolution

Execute this script using SSMS to see when this table was last updated on backups:
select distinct database_name,
MAX(CASE WHEN [type] = N'D' THEN backup_finish_date END) [FullBackup],
MAX(CASE WHEN [type] = N'I' THEN backup_finish_date END) [DifferentialBackup],
MAX(CASE WHEN [type] = N'L' THEN backup_finish_date END) [LogBackup]
from msdb.dbo.backupset
where db_id(database_name) is not null
group by database_name

Feedback Submitted

Was this article helpful?

Select Rating

Title