返回
-
标题
Backup is not recognized by SpotLight -
说明
When using 3rd party application (e.g. Symantec Backup Exec) to do backup for SQL Sever, Spotlight still fires alarm stating that backups have not been done. -
解决办法
Spotlight gets backup information from DMV msdb.dbo.backupset: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.backupsetwhere db_id(database_name) is not nullgroup by database_nameAny 3rd party backup application must write into msdb.dbo.backupset for Spotlight to reconginze the backup.