Wednesday 20 July 2011

Backup time details for database in Sql Server

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