PRINT '================================'
PRINT ' Backup time for database'
PRINT '================================'
SELECT database_name,backup_size,backup_start_date,backup_finish_date,convert(decimal(5,2),datediff(ss,backup_start_date,backup_finish_date)/60.00) "Backup time"
from msdb.dbo.backupset
where convert(varchar,backup_start_date,101)=convert(varchar,getdate()-1,101)
order by backup_start_date desc
No comments:
Post a Comment