sys.pdw_loader_backup_runs (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

Contains information about ongoing and completed backup and restore operations in 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_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 cancelled.
total_elapsed_time int Total time elapsed between start_time and current time, or between start_time and end_time for completed, cancelled, 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
DIFFERENTIAL
FULL

For operation_type = LOAD
APPEND
RELOAD
UPSERT

For operation_type = RESTORE
DATABASE
HEADER_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 (Transact-SQL).
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 (Transact-SQL).
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.

See Also

SQL Data Warehouse and Parallel Data Warehouse Catalog Views