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

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
blockReason	string	The reason why restore is in Blocked state.
currentBackupType	string	Current backup type.
currentRestorePlanSizeMB	integer	Current restore plan size MB.
currentRestoredSizeMB	integer	Current restored size MB.
currentRestoringFileName	string	Current restoring file name.
diffBackupSets	array	Diff backup sets.
fullBackupSets	array	Full backup sets.
lastRestoredFileName	string	Last restored file name.
lastRestoredFileTime	string (date-time)	Last restored file time.
lastUploadedFileName	string	Last uploaded file name.
lastUploadedFileTime	string (date-time)	Last uploaded file time.
logBackupSets	array	Log backup sets.
numberOfFilesDetected	integer	Number of files detected.
numberOfFilesQueued	integer	Number of files queued.
numberOfFilesRestored	integer	Number of files restored.
numberOfFilesRestoring	integer	Number of files restoring.
numberOfFilesSkipped	integer	Number of files skipped.
numberOfFilesUnrestorable	integer	Number of files unrestorable.
percentCompleted	integer	Percent completed.
status	string	Restore status.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
unrestorableFiles	array	Unrestorable files.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, managed_instance_name, database_name, restore_details_name, subscription_id		Gets managed database restore details.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
database_name	string	The name of the database. Required.
managed_instance_name	string	The name of the managed instance. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
restore_details_name	string	The name of the restore details to retrieve. "Default" Required.
subscription_id	string

SELECT examples

get

Gets managed database restore details.

SELECT
id,
name,
blockReason,
currentBackupType,
currentRestorePlanSizeMB,
currentRestoredSizeMB,
currentRestoringFileName,
diffBackupSets,
fullBackupSets,
lastRestoredFileName,
lastRestoredFileTime,
lastUploadedFileName,
lastUploadedFileTime,
logBackupSets,
numberOfFilesDetected,
numberOfFilesQueued,
numberOfFilesRestored,
numberOfFilesRestoring,
numberOfFilesSkipped,
numberOfFilesUnrestorable,
percentCompleted,
status,
systemData,
type,
unrestorableFiles
FROM azure.sql.managed_database_restore_details
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND managed_instance_name = '{{ managed_instance_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND restore_details_name = '{{ restore_details_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;