Share via

Restorable Dropped Managed Databases - Get

  • Reference
Service:
SQL Database
API Version:
2021-11-01

Gets a restorable dropped managed database.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/restorableDroppedDatabases/{restorableDroppedDatabaseId}?api-version=2021-11-01

URI Parameters

Name In Required Type Description
managedInstanceName
 path True

string

The name of the managed instance.
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.
restorableDroppedDatabaseId
 path True

string

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

RestorableDroppedManagedDatabase

Successfully retrieved the specified restorable dropped database.
Other Status Codes

*** Error Responses: ***

  • 400 InvalidRestorableDroppedDatabaseDeletionDate - The restorable dropped database deletion date given is invalid

  • 400 InvalidRestorableDroppedDatabaseId - Invalid restorable dropped database identifier

  • 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.

Examples

Gets a restorable dropped managed database.

Sample request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Test1/providers/Microsoft.Sql/managedInstances/managedInstance/restorableDroppedDatabases/testdb,131403269876900000?api-version=2021-11-01

Sample response

Status code:
200 
{
  "properties": {
    "databaseName": "testdb",
    "creationDate": "2017-05-07T04:41:33.937Z",
    "deletionDate": "2017-05-27T02:49:47.69Z"
  },
  "location": "southeastasia",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/restorableDroppedDatabases/testdb,131403269876900000",
  "name": "testdb,131403269876900000",
  "type": "Microsoft.Sql/managedInstances/restorableDroppedDatabases"
}

Definitions

RestorableDroppedManagedDatabase

A restorable dropped managed database resource.

Name Type Description
id

string

Resource ID.
location

string

Resource location.
name

string

Resource name.
properties.creationDate

string

The creation date of the database (ISO8601 format).
properties.databaseName

string

The name of the database.
properties.deletionDate

string

The deletion date of the database (ISO8601 format).
properties.earliestRestoreDate

string

The earliest restore date of the database (ISO8601 format).
tags

object

Resource tags.
type

string

Resource type.