# restorehistory - Catalog: `msdb` - Schema: `dbo` - Primary Keys: `restore_history_id` The data in this table is partitioned per value of the column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `restorehistory` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `backup_set_id` | `int32` | | ☐ | | | `destination_database_name` | `string` | | ☐ | | | `device_count` | `int16` | | ☐ | | | `recovery` | `boolean` | | ☐ | | | `replace` | `boolean` | | ☐ | | | `restart` | `boolean` | | ☐ | | | `restore_date` | `datetime` | | ☐ | | | `restore_history_id` | `int32` | | ☐ | | | `restore_type` | `char` | | ☐ | | | `stop_at` | `datetime` | | ☐ | | | `stop_at_mark_name` | `string` | | ☐ | | | `stop_before` | `boolean` | | ☐ | | | `user_name` | `string` | | ☐ | |