• if you have no access to this server a restore of the msdb on your server as a user database would give you the information you need, no other information is needed.

    You could ask them to run this query and return the results to you

    SELECT [rs].[destination_database_name],

    [rs].[restore_date],

    [bs].[backup_start_date],

    [bs].[backup_finish_date],

    [bs].[database_name] as [source_database_name],

    [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]

    where [rs].[destination_database_name] = 'SGCTI'

    ORDER BY [rs].[restore_date] DESC

    If you restored the msdb you would have to amend the database name you queried in the code above

    ---------------------------------------------------------------------