Restorable Dropped Databases - Get
Gets a deleted database that can be restored
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/restorableDroppedDatabases/{restorableDroppededDatabaseId}?api-version=2014-04-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
resource
|
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. |
restorable
|
path | True |
string |
The id of the deleted database in the form of databaseName,deletionTimeInFileTimeFormat |
server
|
path | True |
string |
The name of the server. |
subscription
|
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 |
OK |
Examples
Get a restorable dropped database
Sample request
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/restorabledroppeddatabasetest-1257/providers/Microsoft.Sql/servers/restorabledroppeddatabasetest-2389/restorableDroppedDatabases/restorabledroppeddatabasetest-7654,131403269876900000?api-version=2014-04-01
Sample response
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/restorabledroppeddatabasetest-1257/providers/Microsoft.Sql/servers/restorabledroppeddatabasetest-2389/restorableDroppedDatabases/restorabledroppeddatabasetest-7654,131403269876900000",
"name": "restorabledroppeddatabasetest-7654,131403269876900000",
"type": "Microsoft.Sql/servers/restorableDroppedDatabases",
"location": "Japan East",
"properties": {
"databaseName": "restorabledroppeddatabasetest-7654",
"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"
}
}
Definitions
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. |