Post reply

URGENT - Restore Information

  • October 11, 2005 at 4:09 pm

    #169289

    Is there any means to know, when was a particular DB restored? Any query or any place in the enterprise manager where we can find this? This is a bit urgent and any help would be great!

    THanks so much..

    Manoj.

  • October 11, 2005 at 4:23 pm

    #596678

    The restore history table in the msdb database contains a row for each restore operation that has occurred.

    hth

    David

  • October 11, 2005 at 5:56 pm

    #596688

    That's the answer! 🙂 Thanks so much David.

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

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