Right now we experience backup chain problem that we are doing full + differential by using litespeed.
But our vendor doing another full backup themselves and that we guess is doing just between our full and diff, so when we tried to restore the diff. backup, SQL will complain that the backup chain has been broken. So we can't restore our differential backup.
someone give the following script for me to check backup but I can't see how to make the most out of it, please help to coach me what column of information I should use in order to proof/check it:
select * from msdb..backupset bs
inner join msdb..backupmediafamily bf
on bs.media_set_id = bf.media_set_id
where database_name = 'database name'
the physical_device_name cleare to be the backup file output name, but i don't see the differential backup deive name, so it don't exist ?? I can't see why.