I'd suggest to create a linked server to your production server and then query the system tables on your production server to see what the filename(s) of the last full backup(s) is/are. You can even go so far to also query for any Incremental backup file names after that full to stay completely up2date.