Backup--查看备份的历史记录

--====================================================

--查看数据库备份的详细信息:时间存储地址最大/最小LSN

SELECT * FROM msdb.dbo.backupset AS BS

INNER JOIN msdb.dbo.backupfile AS BF

ON BF.backup_set_id=BS.backup_set_id

INNER JOIN msdb.dbo.backupmediaset AS BMS

ON BMS.media_set_id=BS.media_set_id

INNER JOIN msdb.dbo.backupmediafamily AS BMF

ON BMF.media_set_id=BMS.media_set_id

ORDER BY BS.backup_finish_date DESC

Backup--查看备份的历史记录

上一篇:linux下nginx安装


下一篇:form表单中的submit点击时阻止提交