Backup overwrite

• jitendra.padhiyar

  SSCertifiable

  Points: 5824

  More actions

  April 18, 2013 at 3:00 am

  #276516

  Hello Masters,

  Is it possible to know when last backup was restored on specific database ?

  Is it possible to know if any database has been overwrite ?

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  April 18, 2013 at 3:08 am

  #1607594

  You should find all the information you need in the restorehistory table in msdb.

  John