Post reply

How to see when and who did the latest restore of a database?

  • March 27, 2018 at 5:59 am

    #328119

    Dear all,

    How to see when and who did the latest restore of a database?

    Thank you very much

  • March 27, 2018 at 6:43 am

    #1984643

    sql server log

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 27, 2018 at 8:11 am

    #1984655

    river1 - Tuesday, March 27, 2018 5:59 AM

    Dear all,

    How to see when and who did the latest restore of a database?

    Thank you very much

    You can also check the restorehistory table in msdb.
    It can be impacted by msdb maintenance, regularly running the stored procedures to delete backup history so how far back it goes depends on this.

    Sue

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

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