• I don't know if it's the best way (but its work) :

    DECLARE @backup nvarchar(90);

    SELECT TOP 1 @backup = physical_device_name

    FROM msdb.dbo.backupset b JOIN msdb.dbo.backupmediafamily m

    ON b.media_set_id = m.media_set_id

    WHERE database_name = 'dbsqware_mssql'

    ORDER BY backup_finish_date DESC

    RESTORE VERIFYONLY FROM disk= @backup