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.


11
0
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

Description

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 Microsoft 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 Microsoft 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.