SELECT CONVERT(CHAR(100), SERVERPROPERTY(‘Servername’)) AS SERVER ,msdb.dbo.backupset.database_name ,msdb.dbo.backupset.backup_start_date ,msdb.dbo.backupset.backup_finish_date ,msdb.dbo.backupset.expiration_date ,CASE msdb..backupset.type WHEN ‘D’ THEN ‘Database’ WHEN ‘L’ THEN ‘Log’ END … Continue reading Backup History