Post reply

Restore History - Time taken for the restores

  • April 8, 2014 at 8:49 am

    #306073

    Hello,

    I got a requirement from the client asking for database restore duration's for the last couple of months. I can figure out all the information from restorehistory table except the restore times. Can anyone help me with this?

    Thanks,

    Nick

  • April 8, 2014 at 9:24 am

    #1704177

    You could get that information from the default trace that is running on your server. You should have a trace running with the ID = 1 and it should capture the command 'RESTORE DATABASE %'.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • April 8, 2014 at 9:43 am

    #1704185

    Thanks Keith for the reply.

    I tried querying the default trace log but endtime column only has null values. I have the start time but no data in the endtime. Am I missing something?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply