发布-日期: 2015年11月4日 (评论)
这里是一些可以帮助你找到备份的位置的SQL逻辑(logic)。
Here’s some SQL Logic to help you find where your backups are located.
use master;
set nocount on
select
'database' = upper(bs.database_name)
, 'time_of_backup' = replace(replace(replace(left(max(bs.backup_finish_date), 19),':', '-'), 'AM', 'am'), 'PM', 'pm') + ' ' + datename(dw, max(bs.backup_finish_date))
, 'location' = reverse(right(reverse(upper(bmf.physical_device_name)), len(bmf.physical_device_name) - charindex('\',reverse(bmf.physical_device_name),1) + 1))
, 'backup_file' = right(bmf.physical_device_name, charindex('\', reverse('\' + bmf.physical_device_name)) - 1)
from
msdb.dbo.backupset bs join msdb.dbo.backupmediafamily bmf on bs.media_set_id = bmf.media_set_id
--where
-- bs.backup_finish_date > (select getdate()- 30)
-- and bs.database_name = 'COLLECTIONS'
group by
bs.database_name, bs.backup_finish_date, bmf.physical_device_name
order by
bs.database_name, bs.backup_finish_date desc
Build Quality | Build History | ||||
---|---|---|---|---|---|
- 李聪明的数据库 Lee's Clever Data
- Mike的数据库宝典 Mikes Database Collection
- 李聪明的数据库 "Lee Songming"