sysrestoredetail (version 6.5)

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.

Foreign Key

In the sysrestoredetail table there is a Foreign Key constraint fk_restore_id on the restore_id column of the sysrestorehistory table.