Msdb Table Backupmediafamily Does Not Show Transaction Log Backup Sometimes

Hello,


We have a self-written procedure to restore transaction logs on a standby server (Sql Server 2000 sp4)
We do this by joining 2 msdb tables, to find out which backups have been performed: backupmediafamily and backupset.
Sometimes backups are NOT registred in table msdb..backupmediafamily.
Underneath 2 examples.



OK- underneath queries shows the time the backup was created in the physical_device_name; joined with media_set_id
99% shows these correct data



select media_set_id, physical_device_name from backupmediafamily where media_set_id = 258716

media_set_id physical_device_name
258716 H:Mssql2000MSSQLBACKUPPAPPS10_tlog_200701010030.TRN


select media_set_id, backup_start_date , backup_finish_date, database_name from backupset where media_set_id = 258716
media_set_id backup_start_date backup_finish_date database_name
258716 2007-01-01 00:30:08.000 2007-01-01 00:30:08.000 PAPPS10





NOT ok

select media_set_id, physical_device_name from backupmediafamily where media_set_id = 376467

media_set_id backup_start_date backup_finish_date database_name
376467 2007-02-17 09:00:14.000 2007-02-17 09:00:14.000 PDBTIME
376467 2007-10-31 19:15:05.000 2007-10-31 19:15:05.000 PJAVA




select media_set_id, backup_start_date , backup_finish_date, database_name from backupset where media_set_id = 376467

media_set id physical_device_name
376467 H:Mssql2000MSSQLBACKUPPDBTIME_tlog_200702170900.TRN
!!! No record for backup transaction log database PJAVA




select media_set_id, physical_device_name from backupmediafamily where physical_device_name like '%PJAVA%2007103119%'

media_set_id physical_device_name
1115347 H:Mssql2000MSSQLBACKUPPJAVA_tlog_200710311900.TRN
1115432 H:Mssql2000MSSQLBACKUPPJAVA_tlog_200710311930.TRN
1115475 H:Mssql2000MSSQLBACKUPPJAVA_tlog_200710311945.TRN

Missing record for backup made on 2007-10-31 19:15 hours !!!!

Hope somebody can help me.

Best regards,

hvdtol