Question

Does anyone know any tactics to determine if backup exec is taking backup? We do not have access to the program to determine if it is in charge but are receiving alerts for failed backups. If you run the select * from dbo.backupmediaset for System databases it normally returns what software is being used, however Backup Exec will still return SQL Server.

后继器战术也不适用于任何用户数据库,因为它只包括在ms制系统中。

任何帮助都将受到高度赞赏。成就

Answer 1

你们是否尝试使用拖船,而不是拖船?

SELECT TOP 20 database_name,
              type,
              backup_start_date, 
              backup_finish_date,
              compressed_backup_size,
              backup_size
FROM   msdb.dbo.backupset
ORDER  BY backup_set_id DESC;

这就是我使用的情况,背书表格应当有一个历史,所有备份都应在座机上运行,除非有人手工提炼这个表格,而这个表格经常被忽视。

More details at my blog: http://stevestedman.com/2012/01/latest-backups/

我希望这一帮助。一天!

友情链接