managed_database_restore_details

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

Overview

Name	managed_database_restore_details
Type	Resource
Id	azure.sql.managed_database_restore_details

Fields

vw_managed_database_restore_details

Name	Datatype	Description
block_reason	text	field from the properties object
current_backup_type	text	field from the properties object
current_restore_plan_size_mb	text	field from the properties object
current_restored_size_mb	text	field from the properties object
current_restoring_file_name	text	field from the properties object
databaseName	text	field from the properties object
diff_backup_sets	text	field from the properties object
full_backup_sets	text	field from the properties object
last_restored_file_name	text	field from the properties object
last_restored_file_time	text	field from the properties object
last_uploaded_file_name	text	field from the properties object
last_uploaded_file_time	text	field from the properties object
log_backup_sets	text	field from the properties object
managedInstanceName	text	field from the properties object
number_of_files_detected	text	field from the properties object
number_of_files_queued	text	field from the properties object
number_of_files_restored	text	field from the properties object
number_of_files_restoring	text	field from the properties object
number_of_files_skipped	text	field from the properties object
number_of_files_unrestorable	text	field from the properties object
percent_completed	text	field from the properties object
resourceGroupName	text	field from the properties object
restoreDetailsName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	field from the properties object
unrestorable_files	text	field from the properties object

managed_database_restore_details

Name	Datatype	Description
properties	object	The managed database's restore details properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, managedInstanceName, resourceGroupName, restoreDetailsName, subscriptionId	Gets managed database restore details.

SELECT examples

Gets managed database restore details.

vw_managed_database_restore_details

SELECT
block_reason,
current_backup_type,
current_restore_plan_size_mb,
current_restored_size_mb,
current_restoring_file_name,
databaseName,
diff_backup_sets,
full_backup_sets,
last_restored_file_name,
last_restored_file_time,
last_uploaded_file_name,
last_uploaded_file_time,
log_backup_sets,
managedInstanceName,
number_of_files_detected,
number_of_files_queued,
number_of_files_restored,
number_of_files_restoring,
number_of_files_skipped,
number_of_files_unrestorable,
percent_completed,
resourceGroupName,
restoreDetailsName,
status,
subscriptionId,
type,
unrestorable_files
FROM azure.sql.vw_managed_database_restore_details
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND restoreDetailsName = '{{ restoreDetailsName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_database_restore_details

SELECT
properties
FROM azure.sql.managed_database_restore_details
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND restoreDetailsName = '{{ restoreDetailsName }}'
AND subscriptionId = '{{ subscriptionId }}';