SQL Database Backup History | SJB -->

This website uses cookies to ensure you get the best experience. More info...

Pages

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

No comments:

Post a Comment