Find out When the Last Full Backup was Taken
The following query shows the last time a full backup was taken on a certain database. select database_name as [Database], a.name [NameOfBackup], user_name as [BackupTakenBy],backup_start_date, backup_finish_date, backup_size as [SizeOfBackup], is_copy_only,has_backup_checksums,