restore_start_date, restore_finish_date column for restorehistory table - by SQLDBA2008

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 421176 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/5/2009 7:22:23 PM
Access Restriction Public


msdb restorehistory has restore_date (restore_start_date) column only.  It would be helpful if both restore_start_date and restore_finish_date are available.  The same as backupset table has both backup_start_date and backup_finish_date.  It is easy for DBA to get backup/restore duration via query.  
Sign in to post a comment.
Posted by Kevin [MSFT] on 10/23/2012 at 9:45 AM
Thank you for your suggestion, however this is not on our roadmap for any near-term releases.
I am accordingly closing this DCR.
Posted by SQLScottGleason on 6/30/2011 at 6:56 AM
Not a Workaround so I'm posting this info here.

SQL 2005 and 2008 R1: The only whay to find the date/time of a restore is to read the sql error log.
Posted by Kevin [MSFT] on 3/13/2009 at 2:45 PM
That is a very useful suggestion.
We will attempt to include this in the next major release of SQL Server.