SQL Database Backup History

Below is the script to get information about the each type of the successful backups for each databases.

1
2
3
4
USE msdb
SELECT name, user_name, first_lsn, last_lsn, database_backup_lsn,
backup_start_date, backup_finish_date, type, database_name,
server_name, machine_name, compressed_backup_size FROM backupset