Home Dashboard Directory Help
Search

restore_start_date, restore_finish_date column for restorehistory table by SQLDBA2008


Status: 

Closed
 as Won't Fix Help for as Won't Fix


10
0
Sign in
to vote
Type: Suggestion
ID: 421176
Opened: 3/5/2009 7:22:23 PM
Access Restriction: Public
0
Workaround(s)
view

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.
Details
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.
Sign in to post a workaround.