recoverable_managed_databases

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

Overview

Name	recoverable_managed_databases
Type	Resource
Id	azure.sql.recoverable_managed_databases

Fields

vw_recoverable_managed_databases

Name	Datatype	Description
last_available_backup_date	text	field from the properties object
managedInstanceName	text	field from the properties object
recoverableDatabaseName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

recoverable_managed_databases

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, recoverableDatabaseName, resourceGroupName, subscriptionId	Gets a recoverable managed database.

SELECT examples

Gets a recoverable managed database.

vw_recoverable_managed_databases

SELECT
last_available_backup_date,
managedInstanceName,
recoverableDatabaseName,
resourceGroupName,
subscriptionId
FROM azure.sql.vw_recoverable_managed_databases
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND recoverableDatabaseName = '{{ recoverableDatabaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

recoverable_managed_databases

SELECT
properties
FROM azure.sql.recoverable_managed_databases
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND recoverableDatabaseName = '{{ recoverableDatabaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';