restorable_dropped_databases

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

Overview

Name	restorable_dropped_databases
Type	Resource
Id	azure.sql.restorable_dropped_databases

Fields

vw_restorable_dropped_databases

Name	Datatype	Description
backup_storage_redundancy	text	field from the properties object
creation_date	text	field from the properties object
database_name	text	field from the properties object
deletion_date	text	field from the properties object
earliest_restore_date	text	field from the properties object
keys	text	field from the properties object
location	text	Resource location.
max_size_bytes	text	field from the properties object
resourceGroupName	text	field from the properties object
restorableDroppedDatabaseId	text	field from the properties object
serverName	text	field from the properties object
sku	text	An ARM Resource SKU.
subscriptionId	text	field from the properties object
tags	text	Resource tags.

restorable_dropped_databases

Name	Datatype	Description
location	string	Resource location.
properties	object	The restorable dropped database's properties.
sku	object	An ARM Resource SKU.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, restorableDroppedDatabaseId, serverName, subscriptionId	Gets a restorable dropped database.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Gets a list of restorable dropped databases.

SELECT examples

Gets a list of restorable dropped databases.

vw_restorable_dropped_databases

SELECT
backup_storage_redundancy,
creation_date,
database_name,
deletion_date,
earliest_restore_date,
keys,
location,
max_size_bytes,
resourceGroupName,
restorableDroppedDatabaseId,
serverName,
sku,
subscriptionId,
tags
FROM azure.sql.vw_restorable_dropped_databases
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

restorable_dropped_databases

SELECT
location,
properties,
sku,
tags
FROM azure.sql.restorable_dropped_databases
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';