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
Posted by WraithNath at 16:01
Labels:

3 comments:

  1. Unknown4 November 2014 at 06:34

    This comment has been removed by the author.

    ReplyDelete
  2. Unknown4 November 2014 at 06:35

    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

Subscribe to: Post Comments (Atom)