How to find out the last updated or last restore date

[jackps]

Dear all
Can anyone please tell me how to find out the database last updated time / date?
Also if i had restored the database, will it be any record or log i can find out exactly which date the database had been restored?

Thx a lot

Jack

 

[SonOfEmidec1100]

You can run this query to get the restore history, it will give who,when what...

select * from msdb..restorehistory

 

[jackps]

Dear SonofEmidec
As you had provide me the query, which it doesn't work on my database!
Here is what i typed for my query :
select * from MF3.restorehistory
then it got an error :
'Invalid object name 'mfx003.restorehistory'.

 

[ClaireHCM]

Restorehistory is a system table which will be stored only in msdb database.So when you specify it in mfx003 user database,of course it will show invalid object.

Execute "select * from msdb..restorehistory"
will give you the records of restore_date