• Hi - thanks for the script, it's great.

    I have one (probably rookie) question: It appears to only select from msdb.dbo.backupmediafamily where device_type = 2. We have some backups where the device type = 102 (still disc) Was there any reason for that?

    Thanks,

    Tim