Contains a row for each device that comprises a dump.
Note that the columns are the same as for sysbackupdetail except that the backup_id column is called restore_id, and it refers to the corresponding row in sysrestorehistory.
These are the columns in the sysrestoredetail table.
Column | Datatype | Description |
---|---|---|
restore_id | int | Specifies the foreign key that corresponds to the sysbackuphistory record. |
device_type | smallint | Represents a device type. The supported numerical values: 2 Disk 3 Floppy 5 Tape 6 Pipe +100 if restoring from a named device. Cannot be NULL. |
device_name | varchar(255) | Specifies the device or Universal Naming Convention (UNC) name. |
backup_size | int | Specifies, in kilobytes, the size of the backup on this device. Cannot be NULL. |
volume_name | varchar(6) | Specifies a volume ID or label. |
expiration_date | datetime | Specifies the expiration date for the volume. |
In the sysrestoredetail table there is a Foreign Key constraint fk_restore_id on the restore_id column of the sysrestorehistory table.