Contains one row for each completed load operation. The columns match those of sysbackuphistory except that the identity column is called restore_id rather than backup_id and an additional column is added.
These are the columns in the sysrestorehistory table.
| Column | Datatype | Description |
|---|---|---|
| restore_id | int | Specifies the foreign key that corresponds to the sysbackuphistory record. |
| id_number | smallint | Specifies the position of the backup on the volume. |
| backup_type | smallint | Represents the type of backup. These are the supported numerical values: 1 Database 2 Transaction 3 Table |
| source_database_name | varchar(30) | Specifies the source, original, database name. Cannot be NULL. |
| new_database_name | varchar(30) | Specifies the new destination database name. |
| table_owner | varchar(30) | Specifies the name of the person who is the owner of this specific table. |
| table_name | varchar(30) | Specifies the name of the table to be used for table backups. |
| operator_name | char(30) | Specifies the name of the person who performed the last backup. |
| backup_start | datetime | Specifies the date and time of the oldest committed transaction. Cannot be NULL. |
| backup_finish | datetime | Specifies the date and time of the last committed transaction. Cannot be NULL. |
| server_sort | smallint | Specifies the database server's sort order. Cannot be NULL. |
| server_code_page | smallint | Specifies the database server's code page. Cannot be NULL. |
| striped_backup | smallint | Specifies whether the backup is striped. These are the supported numerical values: 1 striped 0 not striped Cannot be NULL. |
| stripe_count | smallint | Specifies the number of devices in the stripeset. Cannot be NULL. |
| stripe_set_name | varchar(30) | Specifies the stripeset name. |
| total_backup_size | int | Specifies the size of the backup in kilobytes. Cannot be NULL. |
| current_sequence | char(14) | Specifies the current or old sequence number. This number matches the Curseq column number returned by the LOAD HEADERONLY statement. Cannot be NULL. |
| new_sequence | char(14) | Specifies the new sequence number. This number matches the Newseq column number returned by the LOAD HEADERONLY statement. |
| restore_date | datetime | Specifies the date and time that the restore operation was performed. Cannot be NULL. |
The clustered index pk_restore_id is created on the primary key restore_id of the sysrestorehistory table.