select a.backup_set_id as '备份集', [name] as '备份名称', [filegroup_name] as '文件组', [user_name] as '执行用户', backup_start_date '备份开始日期', backup_finish_date as '备份结束日期', 备份类型 = case when type = 'D' then '数据库' when type = 'I' then '数据库差异' when type = 'L' then '日志' else '文件或文件组' end, a.database_name as '备份数据库名', logical_name as '备份文件的逻辑名称', physical_name as '驱动器或分区名称', server_name as '运行备份操作的服务器名称', machine_name as '运行备份的计算机名称' from msdb..backupset a,msdb..backupfile b where a.backup_set_id = b.backup_set_id
[name] as '备份名称',
[filegroup_name] as '文件组',
[user_name] as '执行用户',
backup_start_date '备份开始日期',
backup_finish_date as '备份结束日期',
备份类型 = case when type = 'D' then '数据库'
when type = 'I' then '数据库差异'
when type = 'L' then '日志'
else '文件或文件组' end,
a.database_name as '备份数据库名',
logical_name as '备份文件的逻辑名称',
physical_name as '驱动器或分区名称',
server_name as '运行备份操作的服务器名称',
machine_name as '运行备份的计算机名称'
from msdb..backupset a,msdb..backupfile b
where a.backup_set_id = b.backup_set_id