查看mysql 备份历史_SQL Server ->> 查看SQL Server备份历史

---------------------------------------------------------------------------------------------Most Recent Database Backup for Each Database - Detailed-------------------------------------------------------------------------------------------

SELECTA.[Server],

A.database_name,

A.last_db_backup_date,

B.backup_start_date,

B.expiration_date,

B.backup_size,

B.logical_device_name,

B.physical_device_name,

B.backupset_name,

B.descriptionFROM(SELECT

CONVERT(CHAR(100), SERVERPROPERTY('Servername')) ASServer,

msdb.dbo.backupset.database_name,MAX(msdb.dbo.backupset.backup_finish_date) ASlast_db_backup_dateFROMmsdb.dbo.backupmediafamilyINNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id =msdb.dbo.backupset.media_set_idWHERE msdb..backupset.type = 'D'

GROUP BYmsdb.dbo.backupset.database_name

)ASALEFT JOIN(SELECT

CONVERT(CHAR(100), SERVERPROPERTY('Servername')) ASServer,

msdb.dbo.backupset.database_name,

msdb.dbo.backupset.backup_start_date,

msdb.dbo.backupset.backup_finish_date,

msdb.dbo.backupset.expiration_date,

msdb.dbo.backupset.backup_size,

msdb.dbo.backupmediafamily.logical_device_name,

msdb.dbo.backupmediafamily.physical_device_name,

msdb.dbo.backupset.nameASbackupset_name,

msdb.dbo.backupset.descriptionFROMmsdb.dbo.backupmediafamilyINNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id =msdb.dbo.backupset.media_set_idWHERE msdb..backupset.type = 'D')ASBON A.[server] = B.[server] AND A.[database_name] = B.[database_name] AND A.[last_db_backup_date] = B.[backup_finish_date]

ORDER BYA.database_name--Most Recent Database Backup for Each Database

SELECT CONVERT(CHAR(100), SERVERPROPERTY('Servername')) ASServer,

database_name,

backup_start_date,

backup_finish_date,

Backup_duration_in_min,CAST(Backup_duration_in_min/60 AS VARCHAR(10))+'hour(s) and'+CAST(Backup_duration_in_min%60 AS VARCHAR(10))+'minute(s)' AS [description]

FROM(SELECT ROW_NUMBER() OVER(PARTITION BY database_name ORDER BY backup_finish_date) ASrow_no,

database_name,

backup_start_date,

backup_finish_date,DATEDIFF(MINUTE,backup_start_date,backup_finish_date) ASBackup_duration_in_minFROMmsdb.dbo.backupsetWHERE type = 'D') tWHERE row_no = 1

ORDER BYdatabase_name