Why not use this script to get the latest backups ...

SELECT DatabaseName=a.database_name, BackupDate=a.backup_date,

PhysicalDeviceName=physical_device_name,

BackupSize=backup_size,

Duration=duration

FROM

(SELECT sd.name AS database_name,

MAX(bs.backup_finish_date) AS backup_date

FROM master.dbo.sysdatabases sd

LEFT OUTER JOIN msdb.dbo.backupset bs ON sd.name = bs.database_name

LEFT OUTER JOIN

(

SELECT sd.name AS database_name,

MAX(bs.backup_finish_date) AS backup_date,

bm.physical_device_name,

bs.backup_size/1024/1024 as backup_size,

DATEDIFF(mi, bs.backup_start_date, bs.backup_finish_date) as duration

FROM master.dbo.sysdatabases sd

LEFT OUTER JOIN msdb.dbo.backupset bs ON sd.name = bs.database_name

LEFT OUTER JOIN msdb.dbo.backupmediafamily bm ON bm.media_set_id = bs.media_set_id

GROUP BY sd.name, bm.physical_device_name, bs.backup_size/1024/1024,

DATEDIFF(mi, bs.backup_start_date, bs.backup_finish_date)

) sq1

ON sq1.database_name = sd.name

AND sq1.backup_date = bs.backup_finish_date

GROUP BY sd.name ) a,

(SELECT sd.name AS database_name,

MAX(bs.backup_finish_date) AS backup_date,

sq1.physical_device_name,

sq1.backup_size,

sq1.duration

FROM master.dbo.sysdatabases sd

LEFT OUTER JOIN msdb.dbo.backupset bs ON sd.name = bs.database_name

LEFT OUTER JOIN --Must put in nested join

(

SELECT sd.name AS database_name,

MAX(bs.backup_finish_date) AS backup_date,

bm.physical_device_name,

bs.backup_size/1024/1024 as backup_size,

DATEDIFF(mi, bs.backup_start_date, bs.backup_finish_date) as duration

FROM master.dbo.sysdatabases sd

LEFT OUTER JOIN msdb.dbo.backupset bs ON sd.name = bs.database_name

LEFT OUTER JOIN msdb.dbo.backupmediafamily bm ON bm.media_set_id = bs.media_set_id

GROUP BY sd.name, bm.physical_device_name, bs.backup_size/1024/1024,

DATEDIFF(mi, bs.backup_start_date, bs.backup_finish_date)

) sq1

ON sq1.database_name = sd.name

AND sq1.backup_date = bs.backup_finish_date

GROUP BY sd.name, bs.backup_finish_date, sq1.physical_device_name, sq1.backup_size, sq1.duration

) b

where a.database_name=b.database_name

and a.backup_date=b.backup_date

ORDER BY DatabaseName