Find backup set

No matter it is for disaster recovery or refresh QA DEV, you need to know where your backup files are and the timing. Assuming your msdb is still on-line, this script allows you to see all your backup information. If you use SQLAgent to record this on a file, you will have this info even if you lost msdb. It is specially useful when someone add a manual backup that changed your backup-chain and recovery path.

I post a number of different flavors because some people use differential backup, some don't; some do transaction log backup, some don't. Choose the code and modify to suit your purpose.