查询备份时间代码:
SELECT
bs.backup_set_id,
bs.database_name,
bs.backup_start_date,
bs.backup_finish_date,
CAST(CAST(bs.backup_size/1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS [Size],
CAST(DATEDIFF(second, bs.backup_start_date,
bs.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' [TimeTaken],
CASE bs.[type]
WHEN 'D' THEN 'Full Backup'
WHEN 'I' THEN 'Differential Backup'
WHEN 'L' THEN 'TLog Backup'
WHEN 'F' THEN 'File or filegroup'
WHEN 'G' THEN 'Differential file'
WHEN 'P' THEN 'Partial'
WHEN 'Q' THEN 'Differential Partial'
END AS BackupType,
bmf.physical_device_name,
CAST(bs.first_lsn AS VARCHAR(50)) AS first_lsn,
CAST(bs.last_lsn AS VARCHAR(50)) AS last_lsn,
bs.server_name,
bs.recovery_model
FROM msdb.dbo.backupset bs
INNER JOIN msdb.dbo.backupmediafamily bmf
ON bs.media_set_id = bmf.media_set_id
WHERE database_name='SEWAssetDepreciation'
ORDER BY bs.server_name,bs.database_name,bs.backup_start_date desc;
GO
显示最近一次的备份:
5414
SEWAssetDepreciation
2021-10-14 22:01:01.000
2021-10-14 22:01:10.000
18 MB
9 Seconds
Full Backup
{E8E01DCD-FCBC-4CD7-9DCD-11A0C724211D}5
293000000438500327
293000000442800001
TIAFIS085
SIMPLE
但是bak文件的修改日期为2019/1/10