Post reply

Is it possible to find what was the STOPAT time used in point in restore.

  • March 16, 2014 at 5:01 pm

    #286810

    Hi All,

    Recently I restored a database using Point In Time Restore method. While restoring database I used a STOPAT time which is given by developing team. But they are saying I used another(wrong) STOPAT time. I tried to find STOPAT time to showing proof but I couldn't exact query for find STOPAT time.

    Could you please let me know, Is it possible to find what was the STOPAT time used in point in restore?

    Thanks,

    Raja

  • March 16, 2014 at 11:03 pm

    #1697548

    Take a look at the msdb.dbo.restorehistory table. Take a look at the "stop_at" column, a datetime value.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • March 17, 2014 at 11:01 am

    #1697734

    Thank you Shawn Melton.

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

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