Query database backup history

There are a lot of methods to back up the SQL database, but no one has mentioned the method to query the database backup history. I have published the command to query the backup history in SQL2000, if you are interested or have already done so, you may leave a message to discuss it.

 

 

-- After the backup is successful, records will be added to the backupmediafamily, backupset, backupfile, backupmediaset, restorefile, restorefilegroup, and restorehistory tables of the MSDB database.

-- Query backup history

Use MSDB

Select F. *, B. database_name, B. backup_finish_date from backupmediafamily F, backupset B where B. media_set_id = f. media_set_id

And B. database_name = 'database name'

Order by backup_finish_date