SSIS中的备份数据库任务

尝试执行以下查询以获取任务创建的备份名称。相同的数据可以存储到一个变量中并传递给还原。

select top 1
    bs.database_name,
    bmf.physical_device_name
from
    msdb.dbo.backupset as bs
    inner join
    msdb.dbo.backupmediafamily as bmf
    on bmf.media_set_id = bs.media_set_id
where
    bs.database_name = 'master' --mention your database name
    and bs.type = 'D'
order by
    bs.backup_start_date desc