Execute the above SQL script in SSMS. Tested the above script on SQL Server 2008 R2.
More information about Backupsets can be found on the following website
http://technet.microsoft.com/en-us/library/ms186299(v=sql.105).aspx
--------------------------------- --Days Since Last Backup of data. --------------------------------- SELECTDATABASE_NAME, CONVERT( VARCHAR(20) , MAX(BACKUP_FINISH_DATE)) AS LAST_BACKUP, DATEDIFF(D, MAX(BACKUP_FINISH_DATE), GETDATE()) AS DAYS_SINCE_LAST_BACKUP FROMMSDB.DBO.BACKUPSET WHERETYPE = 'D' GROUP BYDATABASE_NAME ORDER BYDAYS_SINCE_LAST_BACKUP DESC
2014-01-30 (first published: 2012-10-07)
2,036 reads
The Microsoft SQL Server team has made it easy for you to retrieve the information in a backup file by using a couple of commands. Read on to learn more!
2019-09-03
