This comment has been removed by the author.
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.ThanksAditya
Hi,You are welcome, I'm glad it helped :)