Recoverable Databases - Get

Gets a recoverable database, which is a resource representing a database's geo backup

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/recoverableDatabases/{databaseName}?api-version=2014-04-01

URI Parameters

Name In Required Type Description
subscriptionId
path True
  • string

The subscription ID that identifies an Azure subscription.

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.

serverName
path True
  • string

The name of the server.

databaseName
path True
  • string

The name of the database

api-version
query True
  • string

The API version to use for the request.

Responses

Name Type Description
200 OK

OK

Examples

Get a recoverable database

Sample Request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/recoverabledatabasetest-6852/providers/Microsoft.Sql/servers/recoverabledatabasetest-2080/recoverableDatabases/recoverabledatabasetest-9187?api-version=2014-04-01

Sample Response

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/recoverabledatabasetest-6852/providers/Microsoft.Sql/servers/recoverabledatabasetest-2080/recoverabledatabases/recoverabledatabasetest-9187",
  "name": "recoverabledatabasetest-9187",
  "type": "Microsoft.Sql/servers/recoverabledatabases",
  "properties": {
    "edition": "Basic",
    "serviceLevelObjective": "Basic",
    "lastAvailableBackupDate": "2017-05-26T01:06:29.78Z",
    "elasticPoolName": null
  }
}

Definitions

RecoverableDatabase

A recoverable database

Name Type Description
id
  • string

Resource ID.

name
  • string

Resource name.

properties.edition
  • string

The edition of the database

properties.elasticPoolName
  • string

The elastic pool name of the database

properties.lastAvailableBackupDate
  • string

The last available backup date of the database (ISO8601 format)

properties.serviceLevelObjective
  • string

The service level objective name of the database

type
  • string

Resource type.