Restorable Dropped Databases - Get

Gets a restorable dropped database.

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

URI Parameters

Name In Required Type Description
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

serverName
path True

string

The name of the server.

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

RestorableDroppedDatabase

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

Sample request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/restorableDroppedDatabases/testdb,131403269876900000?api-version=2021-11-01

Sample response

{
  "sku": {
    "name": "BC_Gen4_2",
    "tier": "BusinessCritical"
  },
  "properties": {
    "databaseName": "testdb",
    "maxSizeBytes": 268435456000,
    "creationDate": "2017-05-07T04:41:33.937Z",
    "deletionDate": "2017-05-27T02:49:47.69Z",
    "backupStorageRedundancy": "Geo"
  },
  "location": "southeastasia",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/restorableDroppedDatabases/testdb",
  "name": "testdb,131403269876900000",
  "type": "Microsoft.Sql/servers/restorableDroppedDatabases"
}

Definitions

Name Description
BackupStorageRedundancy

The storage account type used to store backups for this database.

RestorableDroppedDatabase

A restorable dropped database resource.

Sku

An ARM Resource SKU.

BackupStorageRedundancy

The storage account type used to store backups for this database.

Name Type Description
Geo

string

GeoZone

string

Local

string

Zone

string

RestorableDroppedDatabase

A restorable dropped database resource.

Name Type Description
id

string

Resource ID.

location

string

Resource location.

name

string

Resource name.

properties.backupStorageRedundancy

BackupStorageRedundancy

The storage account type used to store backups for this database.

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

integer

The max size of the database expressed in bytes.

sku

Sku

The name and tier of the SKU.

tags

object

Resource tags.

type

string

Resource type.

Sku

An ARM Resource SKU.

Name Type Description
capacity

integer

Capacity of the particular SKU.

family

string

If the service has different generations of hardware, for the same SKU, then that can be captured here.

name

string

The name of the SKU, typically, a letter + Number code, e.g. P3.

size

string

Size of the particular SKU

tier

string

The tier or edition of the particular SKU, e.g. Basic, Premium.