SQL Server：差异备份已完成，但找不到完整备份

Question

我注意到我的维护计划正在进行差异备份，但我找不到完整备份，所以我不知道它是从哪里进行的。是否可以从差异备份获得完整备份？

Answer 1

SQL Server跟踪备份。也许这会给你指明正确的方向。

;with fullBackup
as
(
select bs.backup_set_id, bs.checkpoint_lsn, bs.database_name, bs.type, bmf.physical_device_name, bs.backup_start_date, bs.backup_finish_date
from msdb..backupset bs
inner join msdb..backupmediaset fms on bs.media_set_id = fms.media_set_id
inner join msdb..backupmediafamily bmf on fms.media_set_id = bmf.media_set_id
where bs.type = 'D' --FULL
)

SELECT 
bs.database_name
, bs.type
, bmf.physical_device_name AS DiffPath
, bs.backup_start_date as DiffStart
, bs.backup_finish_date as DiffEnd
, fb.physical_device_name as FullPath
, fb.backup_start_date as FullStart
, fb.backup_finish_date as FullEnd
from msdb..backupset bs
inner join msdb..backupmediafamily bmf on bs.media_set_id = bmf.media_set_id
left join fullBackup fb on bs.database_backup_lsn = fb.checkpoint_lsn --and bs.database_name = fb.database_name
WHERE bs.type = 'I' --DIFF