Archive

Posts Tagged ‘Database Backup time’

Backup Time Information For a Database

November 30, 2012 Leave a comment

select dbinfo.Name , COALESCE(CONVERT(VARCHAR(20),backuplog.backup_finish_date,100 ),”) as BackupTime
FROM sys.sysdatabases dbinfo
LEFT OUTER JOIN msdb.dbo.backupset backuplog ON backuplog.database_name = dbinfo.name
where dbinfo.Name=’DataBase Name’

Advertisements
%d bloggers like this: