Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL historic restore durations Expand / Collapse
Author
Message
Posted Wednesday, October 10, 2012 3:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 2:22 AM
Points: 229, Visits: 1,155
Morning everyone.
Can anyone point me in the way of a script to detail historic restore durations ?
need to know how long a restore operation took , from start to finish etc.

Cheers for any advice or pointers.
Post #1370783
Posted Wednesday, October 10, 2012 5:03 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
use msdb
go
select * from backupset

Above table can help you.
Post #1370844
Posted Wednesday, October 10, 2012 6:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 25, 2014 8:03 AM
Points: 102, Visits: 1,058

I have found the answers in the below url.

http://stackoverflow.com/questions/3776783/how-can-i-query-how-much-time-a-sql-server-database-restore-takes


Regards,
Kumar
Post #1370894
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse