SQL historic restore durations

• MickyD

  SSCarpal Tunnel

  Points: 4601

  More actions

  October 10, 2012 at 3:19 am

  #282984

  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.

• SQL Show

  SSCertifiable

  Points: 6143

  More actions

  October 10, 2012 at 5:03 am

  #1547587

  use msdb

  go

  select * from backupset

  Above table can help you.

• KumarVelayutham

  SSCrazy

  Points: 2204

  More actions

  October 10, 2012 at 6:39 am

  #1547628

  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