Mengetahui History Backup Database pada SQL Server

bagi yang kadang bingung, “eh ini db udah di restore gak ? “, “waduh tadi aku ngerestore db apa ya ? ” . daripada tetap bingung, mending cek langsung aja pakai query ini

SELECT [r].[destination_database_name] as [Database Name], 
[r].[restore_date] [Restore Date], 
[r].user_name as [User],
(cast([b].software_major_version as varchar(10))+'.' + 
cast([b].software_minor_version as varchar(10)) +'.'+
cast([b].software_build_version as varchar(10))) as [Server version],
[b].compressed_backup_size as [Backup file Size],
[b].[backup_start_date] [Backup Start Time], 
[b].[backup_finish_date][Backup End Time], 
[b].[database_name] as [Source Database Name], 
[bkpmf].[physical_device_name] as [Backup File Used For Database Restore]
FROM msdb..restorehistory r
INNER JOIN msdb..backupset b
ON [r].[backup_set_id] = [b].[backup_set_id]
INNER JOIN msdb..backupmediafamily bkpmf 
ON [b].[media_set_id] = [bkpmf].[media_set_id] 
ORDER BY [r].[restore_date] DESC

Leave a Comment