Restoration date

• Bilichi

  Right there with Babe

  Points: 741

  More actions

  April 14, 2008 at 1:44 am

  #121597

  How to get the last restoration date in database?

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  April 14, 2008 at 2:43 am

  #801947

  select * from msdb..restorehistory where destination_database_name='dbname'

• Bilichi

  Right there with Babe

  Points: 741

  More actions

  April 14, 2008 at 3:03 am

  #801950

  Thanks Maverick

  your query is showing the restoration history.

• shashi kant

  SSCommitted

  Points: 1659

  More actions

  September 10, 2008 at 6:38 am

  #869573

  Thanks Mate,

  This query solves my problem.....

  Regards

  Shashi kant Chauhan:)