sys.pdw_loader_backup_run_details (Transact-SQL)sys.pdw_loader_backup_run_details (Transact-SQL)

適用於: 否SQL Server 否Azure SQL Database 是Azure Synapse Analytics (SQL DW) 是平行處理資料倉儲 APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

包含進一步的詳細的資訊,而不在資訊sys.pdw_loader_backup_runs (TRANSACT-SQL)、 進行中和已完成備份和還原作業中的相關SQL 資料倉儲SQL Data Warehouse以及進行中並完成備份、 還原及載入作業中的平行處理資料倉儲Parallel Data WarehouseContains further detailed information, beyond the information in sys.pdw_loader_backup_runs (Transact-SQL), about ongoing and completed backup and restore operations in SQL 資料倉儲SQL Data Warehouse and about ongoing and completed backup, restore, and load operations in 平行處理資料倉儲Parallel Data Warehouse. 此資訊在系統重新啟動之後會持續存留。The information persists across system restarts.

資料行名稱Column Name 資料類型Data Type 描述Description 範圍Range
run_idrun_id intint 特定的備份或還原執行的唯一識別碼。Unique identifier for a specific backup or restore run.

run_id 和 pdw_node_id 形成這個檢視的索引鍵。run_id and pdw_node_id form the key for this view.
pdw_node_idpdw_node_id intint 此記錄表格包含詳細資料的應用裝置節點的唯一識別碼。Unique identifier of an appliance node for which this record holds details.

run_id 和 pdw_node_id 形成這個檢視的索引鍵。run_id and pdw_node_id form the key for this view.
請參閱中的 node_id sys.dm_pdw_nodes (TRANSACT-SQL)See node_id in sys.dm_pdw_nodes (Transact-SQL).
statusstatus nvarchar(16)nvarchar(16) 執行目前的狀態。The current status of the run. '已取消',' 已完成 ','FAILED'、 '佇列更新'、 'RUNNING''CANCELLED', 'COMPLETED', 'FAILED', 'QUEUED', 'RUNNING'
start_timestart_time datetimedatetime 在這個特定的節點作業開始時間。Time at which the operation started on this particular node.
end_timeend_time datetimedatetime 作業結束時間在這個特定的節點,如果有的話。Time at which the operation ended on this particular node, if any.
total_elapsed_timetotal_elapsed_time intint 在這個特定的節點執行作業的總時間。Total time the operation has been running on this particular node. 如果 total_elapsed_time 超過整數 (以毫秒為單位的 24.8 天) 的最大值,它會具體化失敗,因為溢位。If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow.

以毫秒為單位的最大值相當於 24.8 天。The maximum value in milliseconds is equivalent to 24.8 days.
進度progress intint 以百分比表示作業的進度。Progress of the operation expressed as a percentage. 0 到 100 之間0 to 100

另請參閱See Also

SQL 資料倉儲和平行處理資料倉儲目錄檢視SQL Data Warehouse and Parallel Data Warehouse Catalog Views