Contains one row for each completed dump operation.
These are the columns in the new sysbackuphistory table.
| Column | Datatype | Description |
|---|---|---|
| backup_id | int identity(1,1) | Specifies the primary key. |
| id_number | smallint | Specifies the position of the backup on the volume. |
| backup_type | smallint | Represents the type of backup. The supported numerical values are: 1 Database 2 Transaction 3 Table |
| database_name | varchar(30) | Specifies the database name. |
| table_owner | varchar(30) | Specifies the table owner for table backups. |
| table_name | varchar(30) | Specifies the table name for table backups. |
| operator_name | char(30) | Specifies the name of the person who performed the backup. |
| backup_start | datetime | Specifies the date and time of the oldest committed transaction for TRANSACTION dumps. Otherwise, specifies the date and time the dump was performed. |
| backup_finish | datetime | Specifies the date and time of the last committed transaction for TRANSACTION dumps. Otherwise, specifies the date and time the dump was performed. |
| server_sort | smallint | Specifies the sort order for the database server that performed the dump. |
| server_code_page | smallint | Specifies the character code page for the database server that performed the dump. |
| 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. |
The clustered index, pk_backup_id, is created on the primary key, backup_id, of the sysbackuphistory table.