Gets a recoverable managed database.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/recoverableDatabases/{recoverableDatabaseName}?api-version=2021-11-01
URI Parameters
| Name |
In |
Required |
Type |
Description |
|
managedInstanceName
|
path |
True
|
string
|
The name of the managed instance.
|
|
recoverableDatabaseName
|
path |
True
|
string
|
|
|
resourceGroupName
|
path |
True
|
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
|
path |
True
|
string
|
The subscription ID that identifies an Azure subscription.
|
|
api-version
|
query |
True
|
string
|
The API version to use for the request.
|
Responses
| Name |
Type |
Description |
|
200 OK
|
RecoverableManagedDatabase
|
Successfully retrieved the specified recoverable managed database.
|
|
Other Status Codes
|
|
*** Error Responses: ***
400 InvalidRecoverableDatabaseId - Invalid recoverable database identifier.
400 MiGeoRestoreWithWrongBackupStorageRedundancy - Geo-Restore is not allowed for managed instances with LRS/ZRS backup storage redundancy.
400 UpdatingInstanceAndBackupRedundancy - Instance zone redundancy and backup storage redundancy cannot be updated in the same request.
400 ProvisioningDisabled - Displays error message from resources operation authorizer as is, without changes
400 AadOnlyAuthenticationIsEnabled - Azure Active Directory Only Authentication is enabled. Please contact your system administrator.
400 ManagementServiceFeatureDisabled - User attempted to use a feature which is disabled.
404 SubscriptionDoesNotHaveServer - The requested server was not found
404 ServerNotInSubscriptionResourceGroup - Specified server does not exist in the specified resource group and subscription.
404 ResourceNotFound - The requested resource was not found.
409 ConflictingManagedInstanceOperation - An operation is currently in progress for the managed instance.
409 BackupRedundancyUpdateAndInstanceRedundancyConflict - The instance is multi-az but backup storage is being updated from zone redundant to non-zone redundant.
409 InstanceRedundancyUpdateWhileBackupRedundancyUpdateInProgress - Cannot update instance redundancy because backup storage redundancy update is in progress.
409 InstanceRedundancyUpdateAndBackupRedundancyConflict - The backup storage is non-zone redundant but instance redundancy is being updated to zone redundant.
409 BackupRedundancyUpdateConflict - Cannot update backup storage redundancy because a backup storage redundancy update is already in progress.
409 MiDropFailedOnAuthLocks - User tried to drop last Managed Instance in subnet that has Lock applied on resource(s).
409 MiCreateFailedNonDelegatedSubnet - User tried to deploy Managed Instance or Managed Instance pool in subnet that is not delegated to Microsoft.Sql/managedInstances.
412 InstanceNotReadyForBackupRedundancyUpdate - Cannot update backup storage redundancy because the instance is not ready.
429 SubscriptionTooManyCreateUpdateRequests - Requests beyond max requests that can be processed by available resources.
429 SubscriptionTooManyRequests - Requests beyond max requests that can be processed by available resources.
429 ConflictingSubscriptionOperation - An operation is currently in progress for the subscription.
503 TooManyRequests - Requests beyond max requests that can be processed by available resources.
504 RequestTimeout - Service request exceeded the allowed timeout.
|
Examples
Gets a recoverable databases by managed instances
Sample request
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Test1/providers/Microsoft.Sql/managedInstances/managedInstance/recoverableDatabases/testdb?api-version=2021-11-01
/**
* Samples for RecoverableManagedDatabases Get.
*/
public final class Main {
/*
* x-ms-original-file:
* specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/GetRecoverableManagedDatabase.json
*/
/**
* Sample code: Gets a recoverable databases by managed instances.
*
* @param azure The entry point for accessing resource management APIs in Azure.
*/
public static void
getsARecoverableDatabasesByManagedInstances(com.azure.resourcemanager.AzureResourceManager azure) {
azure.sqlServers().manager().serviceClient().getRecoverableManagedDatabases().getWithResponse("Test1",
"managedInstance", "testdb", com.azure.core.util.Context.NONE);
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
Sample response
{
"properties": {
"lastAvailableBackupDate": "2017-05-26T01:06:29.78Z"
},
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
"name": "testdb",
"type": "Microsoft.Sql/managedInstances/recoverableDatabases"
}
Definitions
RecoverableManagedDatabase
A recoverable managed database resource.
| Name |
Type |
Description |
|
id
|
string
|
Resource ID.
|
|
name
|
string
|
Resource name.
|
|
properties.lastAvailableBackupDate
|
string
|
The last available backup date.
|
|
type
|
string
|
Resource type.
|