when I'm execting
SELECT physical_device_name
FROM msdb..backupmediafamily
WHERE media_set_id =
( SELECT media_set_id
FROM msdb..backupmediafamily
WHERE msdb..backupmediafamily.physical_device_name = 'f:\mssql\backup\DBATEST.bak'
)
I'm getting empty result .. Can you help more please?