Post reply

Finding Out When A Database Was Last Restored

  • January 22, 2010 at 9:19 am

    #218503

    We have a database that we use for testing that gets refreshed with a copy of another database (production) from time to time.

    Is there an easy way for me to find when the test database was last restored (overwritten)?

    Thank you.

    Rog

  • January 22, 2010 at 11:27 am

    #1107482

    You can get the details from restorehistory table in msdb database or from error log, or application log.

  • January 22, 2010 at 12:36 pm

    #1107512

    Thank you!

    Rog

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

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