SELECT TOP 1
	BMF.physical_device_name
	,BS.backup_finish_date
FROM
	msdb.dbo.BackupSet BS
JOIN
	msdb.dbo.backupmediafamily BMF
ON
	BS.media_set_id = BMF.media_set_id 
WHERE
	database_name = 'BackupTest'
AND
	type = 'D'
ORDER BY
	BS.backup_finish_date DESC