I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. Would you believe in 20+ years as a DBA I can count the number of database restores for a disaster on my fingers? (Which is good because taking off your shoes at the office is considered bad form.)
I think the important take-away from this post is that you should leave your shoes on at work. You don’t know what kind of disgusting things are in that carpet. Also, read on to learn where to find database restoration history.