I am familiar with the various queries that can be run to return information out of the 'msdb' database for the last date a database was restored, but what I am not certain about is whether the 'restore_date' column from the dbo.restorehistory table is logging when the restore began or when it completed.
Sorry if this is just right under my nose, and I am missing something very obvious here, but I have searched the WEB, BOL, etc, and cannot find anything definitive on this.
Here is a sample of the query I am running...
WHERE destination_database_name = 'MyDatabase'
ORDER BY restore_date DESC
There are obviously much better ways of writing for such information, but you hopefully get the gist of what I am trying to do here.
If anyone can say definitively if it is the start date for the restore, or when the restore completed, that would be great to know. I am learning towards thinking that it is the time the restore started and not completed, but I just want to be sure - and if my assumption is correct - is there a way to query for when the restore completed for a given database?
Thank you in advance!
P.S. No 3rd party tools in use here. These are native backups being restored from, to an Enterprise Edition installation of SQL Server 2005.