last restored

• BLADE-1043594

  SSCrazy

  Points: 2576

  More actions

  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:

• Robert Klimes

  SSCoach

  Points: 17865

  More actions

  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]

• umar iqbal

  SSCommitted

  Points: 1703

  More actions

  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

• umar iqbal

  SSCommitted

  Points: 1703

  More actions

  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

• Stamey

  SSCertifiable

  Points: 5600

  More actions

  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.