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.
Edit 1:
With James Anderson's query, I got this too ( filtering with bckset.[type] ='D
)
Again, I don't have backups from 2015-09-15, only 2015-09-14.
EDIT 2:
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??