Archives
-
SQL Backup History – How to retrieve a list of the most recent database backups
The MSDB database maintains a record of all SQL backup jobs that have been executed. Specifically you can find this information if you query MSDB..backupset. This script joins sys.databases, so that if a database exists but has not been backed up yet, it will still be displayed in the results. If you were to query [...]
Jun 7th, 2009 | Filed under SQL, TechnologyTags: SQL