Restorable Dropped Databases - List By Server

Gets a list of deleted databases that can be restored

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/restorableDroppedDatabases?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.

api-version
query True
  • string

The API version to use for the request.

Responses

Name Type Description
200 OK

OK

Examples

Get list of restorable dropped databases

Sample Request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/restorabledroppeddatabasetest-1349/providers/Microsoft.Sql/servers/restorabledroppeddatabasetest-1840/restorableDroppedDatabases?api-version=2014-04-01

Sample Response

{
  "value": [
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/restorabledroppeddatabasetest-1349/providers/Microsoft.Sql/servers/restorabledroppeddatabasetest-1840/restorableDroppedDatabases/restorabledroppeddatabasetest-1345,131403269876900000",
      "name": "restorabledroppeddatabasetest-1345,131403269876900000",
      "type": "Microsoft.Sql/servers/restorableDroppedDatabases",
      "location": "Japan East",
      "properties": {
        "databaseName": "restorabledroppeddatabasetest-1345",
        "edition": "Basic",
        "maxSizeBytes": "2147483648",
        "serviceLevelObjective": "Basic",
        "elasticPoolName": null,
        "creationDate": "2017-02-10T00:56:19.2Z",
        "deletionDate": "2017-05-27T02:49:47.69Z",
        "earliestRestoreDate": "2017-05-20T02:49:47.69Z"
      }
    },
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/restorabledroppeddatabasetest-1349/providers/Microsoft.Sql/servers/restorabledroppeddatabasetest-1840/restorableDroppedDatabases/restorabledroppeddatabasetest-2764,131403249684030000",
      "name": "restorabledroppeddatabasetest-2764,131403249684030000",
      "type": "Microsoft.Sql/servers/restorableDroppedDatabases",
      "location": "Japan East",
      "properties": {
        "databaseName": "restorabledroppeddatabasetest-2764",
        "edition": "Standard",
        "maxSizeBytes": "268435456000",
        "serviceLevelObjective": "S0",
        "elasticPoolName": null,
        "creationDate": "2016-05-10T00:56:19.2Z",
        "deletionDate": "2017-05-27T02:16:08.403Z",
        "earliestRestoreDate": "2017-04-21T02:49:47.69Z"
      }
    }
  ]
}

Definitions

RestorableDroppedDatabase

A restorable dropped database

RestorableDroppedDatabaseListResult

The response to a list restorable dropped databases request

RestorableDroppedDatabase

A restorable dropped database

Name Type Description
id
  • string

Resource ID.

location
  • string

The geo-location where the resource lives

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)

properties.edition
  • string

The edition of the database

properties.elasticPoolName
  • string

The elastic pool name of the database

properties.maxSizeBytes
  • string

The max size in bytes of the database

properties.serviceLevelObjective
  • string

The service level objective name of the database

type
  • string

Resource type.

RestorableDroppedDatabaseListResult

The response to a list restorable dropped databases request

Name Type Description
value

A list of restorable dropped databases