[SQL Server] Trouver la sauvegarde utilisée pour restaurer la base de données

SELECT r.restore_history_id,r.restore_date,r.restore_type,r.replace

,r.recovery,b.backup_set_id,b.database_name,m.physical_device_name

FROM msdb..backupset b JOIN msdb..backupmediafamily m ON b.media_set_id=m.media_set_id

JOIN msdb..restorehistory r ON r.backup_set_id=b.backup_set_id

WHERE b.database_name LIKE '%MEKTABA%'