Script of the day: Show last backups of all databases

Script of the day: Show last backups of all databases

  • Comments 1

There are lots of these out on the web, so here's the one I've used for years - Thanks, Joseph!

 

/*

usc_Show_Last_Backup.sql

Author: Joseph Sack (6/13/2000)

Edited By: Buck Woody

Purpose: Shows the last time the databases were backed up.

*/

SELECT B.name

as Database_Name,

ISNULL(STR(ABS(DATEDIFF(day, GetDate(), MAX(Backup_finish_date)))), 'NEVER')

as DaysSinceLastBackup,

ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NEVER')

as LastBackupDate

FROM master.dbo.sysdatabases B

LEFT OUTER JOIN msdb.dbo.backupset A

ON A.database_name = B.name

AND A.type = 'D'

GROUP BY B.Name

ORDER BY B.name

Leave a Comment
  • Please add 6 and 4 and type the answer here:
  • Post