Monthly Archives: April 2013

T-SQL Script to Get Last Backup Dates for All Active DB’s

/* Script to list the last full backup time for all active user DB’s. Version: 2005+ */ with tmp as ( select row_number() over (partition by BS.database_name order by BS.backup_set_id desc) as rowid, BS.database_name, BS.backup_finish_date from msdb.dbo.backupset BS inner join … Continue reading

Posted in T-SQL Script | Tagged | Leave a comment