restorehistory: SQL Server
insert update delete
- Catalog:
msdb - Schema:
dbo - Primary Keys:
restore_history_id
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. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
backup_ |
int32 |
||||
destination_ |
varchar2 |
||||
device_ |
int16 |
||||
recovery |
char |
||||
replace |
char |
||||
restart |
char |
||||
restore_ |
datetime |
||||
restore_ |
int32 |
||||
restore_ |
char |
||||
stop_ |
datetime |
||||
stop_ |
varchar2 |
||||
stop_ |
char |
||||
user_ |
varchar2 |