I use this query to list last backup dates of our databases:
SELECT SDB.NAME AS DATABASENAME, COALESCE(CONVERT(VARCHAR(12), MAX(BUS.BACKUP_FINISH_DATE), 101),'-') AS LASTBACKUPTIME FROM SYS.SYSDATABASES SDB LEFT OUTER JOIN MSDB.DBO.BACKUPSET BUS ON BUS.DATABASE_NAME=SDB.NAME GROUP BY SDB.NAME ORDER BY 2 ASC
But today, it shows me "09/15/2015" for all databases, but we had a problem in the cluster, so the backup job didn't run. Why is this query listing "09/15/2015' if there are no backups for today?
last time the job run was 09/14/2015.
With James Anderson's query, I got this too ( filtering with
Again, I don't have backups from 2015-09-15, only 2015-09-14.
With some tests, I see that these queries shows me last backup date, even if I only have log backups. Is there a way to list "last full backup" date??