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

Question

Is it possible to do so using T-SQL alone? What query would you write against the system tables?

Answer 1

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

MSDN - restorehistory

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