หมายเหตุ
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลอง ลงชื่อเข้าใช้หรือเปลี่ยนไดเรกทอรีได้
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลองเปลี่ยนไดเรกทอรีได้
Applies to: 
Azure Synapse Analytics
Contains information about ongoing and completed backup and restore operations in Azure Synapse Analytics, and about ongoing and completed backup, restore. The information persists across system restarts.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
run_id |
int | Unique identifier for a specific backup, restore, or load run. Key for this view. |
|
name |
nvarchar(255) | Null for load. Optional name for backup or restore. | |
submit_time |
datetime | Time the request was submitted. | |
start_time |
datetime | Time the operation started. | |
end_time |
datetime | Time the operation completed, failed, or was canceled. | |
total_elapsed_time |
int | Total time elapsed between start_time and current time, or between start_time and end_time for completed, canceled, or failed runs. |
If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow. The maximum value in milliseconds is equivalent to 24.8 days. |
operation_type |
nvarchar(16) | The load type. | 'BACKUP', 'LOAD', 'RESTORE' |
mode |
nvarchar(16) | The mode within the run type. | For operation_type = BACKUP:DIFFERENTIALFULLFor operation_type = LOAD:APPENDRELOADUPSERTFor operation_type = RESTORE:DATABASEHEADER_ONLY |
database_name |
nvarchar(255) | Name of the database that is the context of this operation | |
table_name |
nvarchar(255) | Information not available. | |
Principal_id |
int | ID of the user requesting the operation. | |
session_id |
nvarchar(32) | ID of the session performing the operation. | See session_id in sys.dm_pdw_exec_sessions. |
request_id |
nvarchar(32) | ID of the request performing the operation. For loads, this is the current or last request associated with this load. | See request_id in sys.dm_pdw_exec_requests. |
status |
nvarchar(16) | Status of the run. | CANCELLED,COMPLETED,FAILED,QUEUED,RUNNING |
progress |
int | Percentage completed. | 0 to 100 |
command |
nvarchar(4000) | Full text of the command submitted by the user. | Will be truncated if longer than 4000 characters (counting spaces). |
rows_processed |
bigint | Number of rows processed as part of this operation. | |
rows_rejected |
bigint | Number of rows rejected as part of this operation. | |
rows_inserted |
bigint | Number of rows inserted into the database table(s) as part of this operation. |