recoverable_databases

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

Overview

Name	recoverable_databases
Type	Resource
Id	azure.sql.recoverable_databases

Fields

vw_recoverable_databases

Name	Datatype	Description
databaseName	text	field from the properties object
edition	text	field from the properties object
elastic_pool_name	text	field from the properties object
keys	text	field from the properties object
last_available_backup_date	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
service_level_objective	text	field from the properties object
subscriptionId	text	field from the properties object

recoverable_databases

Name	Datatype	Description
properties	object	The recoverable database's properties.

Methods

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

SELECT examples

Gets a list of recoverable databases.

vw_recoverable_databases

SELECT
databaseName,
edition,
elastic_pool_name,
keys,
last_available_backup_date,
resourceGroupName,
serverName,
service_level_objective,
subscriptionId
FROM azure.sql.vw_recoverable_databases
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

recoverable_databases

SELECT
properties
FROM azure.sql.recoverable_databases
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';