Skip to main content

Posts

Showing posts with the label desc order by

SQL Database Backup Restore History

To get SQL Database Backup Restore History you can execute below code using msdb database. This table resides in msdb database. SELECT [rs].[destination_db], [rs].[restore_date], [bs].[backup_start_date], [bs].[backup_finish_date], [bs].[database_name] as [source_db], [bmf].[physical_device_name] as [backup_file_used_for_restore] FROM msdb.restorehistory rs INNER JOIN msdb.backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id] INNER JOIN msdb.backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id] ORDER BY [rs].[restore_date] DESC