Home Forums SQL Server 7,2000 Backups Determine Physical Device Name for a backupset. RE: Determine Physical Device Name for a backupset.

  • We recently implemented a new 3rd party backup device but and now we intend to move from he old backup device which seems to be failing .

    Problem- When a backup fails , we currently do not know which of the backup device it was on without doing further digging because both backup devices show up as GUIDS with random hexadecimals as the physical device name.

    Is there any way/script that could Alias these GUIDS as lets say "Tivoli or 'Redgate" please assistance would be appreciated

    Desired outcome- To be able to run a sql script to actually confirm that a certain database is actually backed up to Tivoli