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
The following fields are returned by SELECT
queries:
- get
Successfully retrieved the specified recoverable managed database.
Name | Datatype | Description |
---|---|---|
properties | object | Resource properties. |
Methods
The following methods are available for this resource:
Name | Accessible by | Required Params | Optional Params | Description |
---|---|---|---|---|
get | select | resourceGroupName , managedInstanceName , recoverableDatabaseName , subscriptionId | Gets a recoverable managed database. |
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 |
---|---|---|
managedInstanceName | string | The name of the managed instance. |
recoverableDatabaseName | string | |
resourceGroupName | string | The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. |
subscriptionId | string | The subscription ID that identifies an Azure subscription. |
SELECT
examples
- get
Gets a recoverable managed database.
SELECT
properties
FROM azure.sql.recoverable_managed_databases
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND managedInstanceName = '{{ managedInstanceName }}' -- required
AND recoverableDatabaseName = '{{ recoverableDatabaseName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;