Post reply

last restored

  • March 25, 2009 at 7:09 am

    #129285

    hi,

    i want to know the last date and time of database restoration.please help

    Thanks

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • March 25, 2009 at 7:47 am

    #965985

    Look in sys.databases. create_date is in this system view.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • March 25, 2009 at 8:53 am

    #966019

    here you go for sql 2005

    select * from msdb..restorehistory

    order by restore_date

    :crazy: :alien:

    Umar Iqbal

  • March 25, 2009 at 9:11 am

    #966031

    here you go for sql 2005

    select * from msdb..restorehistory

    order by restore_date

    :crazy: :alien:

    Umar Iqbal

  • March 25, 2009 at 10:38 am

    #966107

    If on 2005, and DB compatibility Level is 90, Right click the DB name from SSMS, choose Reports, Standard Reports, then "Backup And Restore Events", for a nice report with the info in it.

    Chris

    Learning something new on every visit to SSC. Hoping to pass it on to someone else.

Viewing 5 posts - 1 through 4 (of 4 total)

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