restorable_dropped_managed_databases

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

Overview

Name	restorable_dropped_managed_databases
Type	Resource
Id	azure.sql.restorable_dropped_managed_databases

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.
creationDate	string (date-time)	The creation date of the database (ISO8601 format).
databaseName	string	The name of the database.
deletionDate	string (date-time)	The deletion date of the database (ISO8601 format).
earliestRestoreDate	string (date-time)	The earliest restore date of the database (ISO8601 format).
location	string	The geo-location where the resource lives. Required.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_instance

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.
creationDate	string (date-time)	The creation date of the database (ISO8601 format).
databaseName	string	The name of the database.
deletionDate	string (date-time)	The deletion date of the database (ISO8601 format).
earliestRestoreDate	string (date-time)	The earliest restore date of the database (ISO8601 format).
location	string	The geo-location where the resource lives. Required.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

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, restorable_dropped_database_id, subscription_id		Gets a restorable dropped managed database.
list_by_instance	select	resource_group_name, managed_instance_name, subscription_id		Gets a list of restorable dropped managed databases.

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
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.
restorable_dropped_database_id	string	Required.
subscription_id	string

SELECT examples

get

Gets a restorable dropped managed database.

SELECT
id,
name,
creationDate,
databaseName,
deletionDate,
earliestRestoreDate,
location,
systemData,
tags,
type
FROM azure.sql.restorable_dropped_managed_databases
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND managed_instance_name = '{{ managed_instance_name }}' -- required
AND restorable_dropped_database_id = '{{ restorable_dropped_database_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_instance

Gets a list of restorable dropped managed databases.

SELECT
id,
name,
creationDate,
databaseName,
deletionDate,
earliestRestoreDate,
location,
systemData,
tags,
type
FROM azure.sql.restorable_dropped_managed_databases
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND managed_instance_name = '{{ managed_instance_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;