Friday, June 3, 2016

get last backup time of database in Sql server

//Last backupTime Query
SELECT sdb.Name AS DatabaseName,
ISNULL(CONVERT(VARCHAR(214),MAX(bus.backup_finish_date)),’-‘) AS LastBackUpTime
FROM sys.sysdatabases sdb
LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name
GROUP BY sdb.Name

No comments: