Skip to main content

vw_managed_database_restore_details

Creates, updates, deletes, gets or lists a vw_managed_database_restore_details resource.

Overview​

Namevw_managed_database_restore_details
TypeView
Idazure.sql.vw_managed_database_restore_details

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.type') as "type",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.blockReason') as "block_reason",
JSON_EXTRACT(properties, '$.lastUploadedFileName') as "last_uploaded_file_name",
JSON_EXTRACT(properties, '$.lastUploadedFileTime') as "last_uploaded_file_time",
JSON_EXTRACT(properties, '$.lastRestoredFileName') as "last_restored_file_name",
JSON_EXTRACT(properties, '$.lastRestoredFileTime') as "last_restored_file_time",
JSON_EXTRACT(properties, '$.percentCompleted') as "percent_completed",
JSON_EXTRACT(properties, '$.currentRestoredSizeMB') as "current_restored_size_mb",
JSON_EXTRACT(properties, '$.currentRestorePlanSizeMB') as "current_restore_plan_size_mb",
JSON_EXTRACT(properties, '$.currentBackupType') as "current_backup_type",
JSON_EXTRACT(properties, '$.currentRestoringFileName') as "current_restoring_file_name",
JSON_EXTRACT(properties, '$.numberOfFilesDetected') as "number_of_files_detected",
JSON_EXTRACT(properties, '$.numberOfFilesQueued') as "number_of_files_queued",
JSON_EXTRACT(properties, '$.numberOfFilesSkipped') as "number_of_files_skipped",
JSON_EXTRACT(properties, '$.numberOfFilesRestoring') as "number_of_files_restoring",
JSON_EXTRACT(properties, '$.numberOfFilesRestored') as "number_of_files_restored",
JSON_EXTRACT(properties, '$.numberOfFilesUnrestorable') as "number_of_files_unrestorable",
JSON_EXTRACT(properties, '$.fullBackupSets') as "full_backup_sets",
JSON_EXTRACT(properties, '$.diffBackupSets') as "diff_backup_sets",
JSON_EXTRACT(properties, '$.logBackupSets') as "log_backup_sets",
JSON_EXTRACT(properties, '$.unrestorableFiles') as "unrestorable_files",
subscriptionId,
resourceGroupName,
managedInstanceName,
databaseName,
restoreDetailsName
FROM azure.sql.managed_database_restore_details
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managedInstanceName = 'replace-me' AND databaseName = 'replace-me' AND restoreDetailsName = 'replace-me';