Sometimes you may have the need to find out the date and time a particular database was last restored. Here is a simple way to do it. It should work in both SQL Server 2000 and SQL Server 2005:

use msdb
select max(restore_date) from restorehistory where destination_database_name = ‘MyDatabaseName’