sys-pdw-loader-backup-runs-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
sys.pdw_loader_backup_runs (Transact-SQL)	sys.pdw_loader_backup_runs (Transact-SQL)	WilliamDAssafMSFT	wiassaf	04/15/2024	sql	data-warehouse	reference	TSQL	>=aps-pdw-2016||=azure-sqldw-latest

sys.pdw_loader_backup_runs (Transact-SQL)

[!INCLUDE applies-to-version/asa-pdw]

Contains information about ongoing and completed backup and restore operations in [!INCLUDE ssazuresynapse-md], and about ongoing and completed backup, restore, and load operations in [!INCLUDE ssPDW]. 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: 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)	[!INCLUDE ssInfoNA]
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.

Related content

• Azure Synapse Analytics and Analytics Platform System (PDW) catalog views