Contains a row for each device comprising a dump.
These are the columns in the sysbackupdetail table.
| Column | Datatype | Description |
|---|---|---|
| backup_id | int | Specifies the foreign key corresponding to the sysbackuphistory record. Cannot be NULL. |
| device_type | smallint | Represents a device type. Cannot be NULL. These are the supported numerical values: 2 Disk 3 Floppy 5 Tape 6 Pipe +100 if backing up to a named device. |
| device_name | varchar(255) | Specifies the device name. Cannot be NULL. |
| backup_size | int | Specifies the size of the backup on this device in kilobytes. |
| volume_name | varchar(6) | Specifies a volume ID or label. |
| expiration_date | datetime | Specifies the expiration date for the volume. |
In the sysbackupdetail table there is a Foreign Key constraint, fk_backup_id, on the backup_id column of the sysbackuphistory table.