Thursday, 9 December 2010

How to find all database backups in the last week

Here is a useful script to find all backups done on all databases over the last 7 days. The number of days can be changed if necessary:

I found this script over at SQL Tips

3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Thanks for your query :). I was checking on the DB properties to identify which backup file was used to restore this db.
    backupmediafamily and backupset - Helped me to figure out the physical backup location.

    Thanks
    Aditya

    ReplyDelete
    Replies
    1. Hi,

      You are welcome, I'm glad it helped :)

      Delete