sql - Find out when a database backup was made -

People,

Assuming you have a disconnected backup of a SQL Server database (2005 or 2008)

Is there a way, a system catalog or something else, to figure out when the final writing process has taken place on that particular database? I want to know from what day since a particular database backup was - unfortunately, it is not really being recorded anywhere else and for checking the highest date / time ticket, all the dozen data tables are actually a No choice ....

Any thoughts? Of course - I can see the date / time stamp of * .bak file - but can I find out more accurately than within SQL Server (Management Studio) ??

Thank you! Mark

You can try restart on backup file , As

should give you the information you are looking for.