SQL Server 2005: T-SQL to query when the database was last restored?

Question

Can this only be done using T-SQL? What query could you write against system tables?

Answer 1

Use the restore_date field in the restorehistory table in the msdb database.

MSDN - restorehistory

SELECT
MAX(restore_date)
FROM
msdb.dbo.restorehistory
WHERE destination_database_name = 'SomeDB'