你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

Restorable Dropped Databases - Get

服务:: SQL Database

API 版本:: 2023-08-01

获取可还原的已删除数据库。

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

具有可选参数:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/restorableDroppedDatabases/{restorableDroppedDatabaseId}?$expand={$expand}&$filter={$filter}&api-version=2023-08-01

URI 参数

名称	在	必需	类型	说明
resourceGroupName	path	True	string	包含资源的资源组的名称。可以从 Azure 资源管理器 API 或门户获取此值。
restorableDroppedDatabaseId	path	True	string
serverName	path	True	string	服务器的名称。
subscriptionId	path	True	string	标识 Azure 订阅的订阅 ID。
api-version	query	True	string	要用于请求的 API 版本。
$expand	query		string	要包含在响应中的子资源。
$filter	query		string	一个 OData 筛选器表达式，用于筛选集合中的元素。

响应

名称	类型	说明
200 OK	RestorableDroppedDatabase	已成功检索指定的可还原已删除的数据库。
Other Status Codes	ErrorResponse	错误响应： *** 400 ManagedInstanceStoppingOrStopped - 实例处于停止/停止状态时提交的冲突作 400 ManagedInstanceStarting - 实例处于启动状态时提交的冲突作 400 InvalidRestorableDroppedDatabaseDeletionDate - 给定的可还原删除的数据库删除日期无效 400 InvalidRestorableDroppedDatabaseId - 无法还原的已删除数据库标识符 404 ServerNotInSubscriptionResourceGroup - 指定的服务器在指定的资源组和订阅中不存在。 404 SubscriptionDoesNotHaveServer - 找不到请求的服务器 404 ResourceNotFound - 找不到请求的资源。 404 SubscriptionNotFound - 找不到请求的订阅。 429 SubscriptionTooManyRequests - 请求超出可用资源可以处理的最大请求数。 503 TooManyRequests - 请求超出可用资源可以处理的最大请求数。

名称

类型

说明

200 OK

RestorableDroppedDatabase

已成功检索指定的可还原已删除的数据库。

Other Status Codes

ErrorResponse

错误响应： ***

400 ManagedInstanceStoppingOrStopped - 实例处于停止/停止状态时提交的冲突作
400 ManagedInstanceStarting - 实例处于启动状态时提交的冲突作
400 InvalidRestorableDroppedDatabaseDeletionDate - 给定的可还原删除的数据库删除日期无效
400 InvalidRestorableDroppedDatabaseId - 无法还原的已删除数据库标识符
404 ServerNotInSubscriptionResourceGroup - 指定的服务器在指定的资源组和订阅中不存在。
404 SubscriptionDoesNotHaveServer - 找不到请求的服务器
404 ResourceNotFound - 找不到请求的资源。
404 SubscriptionNotFound - 找不到请求的订阅。
429 SubscriptionTooManyRequests - 请求超出可用资源可以处理的最大请求数。
503 TooManyRequests - 请求超出可用资源可以处理的最大请求数。

示例

Gets a restorable dropped database with expand equals keys.

Gets a restorable dropped database.

Gets a restorable dropped database with expand equals keys.

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

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/stable/2023-08-01/examples/GetRestorableDroppedDatabaseWithExpandEqualsKeys.json
// this example is just showing the usage of "RestorableDroppedDatabases_Get" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://free.blessedness.top/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this RestorableDroppedDatabaseResource
RestorableDroppedDatabaseCollection collection = sqlServer.GetRestorableDroppedDatabases();

// invoke the operation
string restorableDroppedDatabaseId = "testdb,131403269876900000";
string expand = "keys";
NullableResponse<RestorableDroppedDatabaseResource> response = await collection.GetIfExistsAsync(restorableDroppedDatabaseId, expand: expand);
RestorableDroppedDatabaseResource result = response.HasValue ? response.Value : null;

if (result == null)
{
    Console.WriteLine("Succeeded with null as result");
}
else
{
    // the variable result is a resource, you could call other operations on this instance as well
    // but just for demo, we get its data from this resource instance
    RestorableDroppedDatabaseData resourceData = result.Data;
    // for demo we just print out the id
    Console.WriteLine($"Succeeded on id: {resourceData.Id}");
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 200

{
  "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",
    "keys": {
      "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion": {},
      "https://your-key-vault-name.vault.azure.net/yourKey2/yourKey2Version": {}
    }
  },
  "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"
}

Gets a restorable dropped database.

示例请求

HTTP
dotnet

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=2023-08-01

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/stable/2023-08-01/examples/GetRestorableDroppedDatabase.json
// this example is just showing the usage of "RestorableDroppedDatabases_Get" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://free.blessedness.top/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this RestorableDroppedDatabaseResource
RestorableDroppedDatabaseCollection collection = sqlServer.GetRestorableDroppedDatabases();

// invoke the operation
string restorableDroppedDatabaseId = "testdb,131403269876900000";
NullableResponse<RestorableDroppedDatabaseResource> response = await collection.GetIfExistsAsync(restorableDroppedDatabaseId);
RestorableDroppedDatabaseResource result = response.HasValue ? response.Value : null;

if (result == null)
{
    Console.WriteLine("Succeeded with null as result");
}
else
{
    // the variable result is a resource, you could call other operations on this instance as well
    // but just for demo, we get its data from this resource instance
    RestorableDroppedDatabaseData resourceData = result.Data;
    // for demo we just print out the id
    Console.WriteLine($"Succeeded on id: {resourceData.Id}");
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 200

{
  "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"
}

定义

名称	说明
BackupStorageRedundancy	用于存储此数据库的备份的存储帐户类型。
DatabaseKey	用于静态加密的数据库级密钥。
DatabaseKeyType	数据库密钥类型。仅支持的值是“AzureKeyVault”。
ErrorAdditionalInfo	资源管理错误附加信息。
ErrorDetail	错误详细信息。
ErrorResponse	错误响应
RestorableDroppedDatabase	可还原的已删除数据库资源。
Sku	ARM 资源 SKU。

BackupStorageRedundancy

枚举

用于存储此数据库的备份的存储帐户类型。

值	说明
Geo
Local
Zone
GeoZone

DatabaseKey

Object

用于静态加密的数据库级密钥。

名称	类型	说明
creationDate	string (date-time)	数据库密钥创建日期。
subregion	string	服务器密钥的子区域。
thumbprint	string	数据库密钥的指纹。
type	DatabaseKeyType	数据库密钥类型。仅支持的值是“AzureKeyVault”。

DatabaseKeyType

枚举

数据库密钥类型。仅支持的值是“AzureKeyVault”。

值	说明
AzureKeyVault

ErrorAdditionalInfo

Object

资源管理错误附加信息。

名称	类型	说明
info	object	其他信息。
type	string	其他信息类型。

ErrorDetail

Object

错误详细信息。

名称	类型	说明
additionalInfo	ErrorAdditionalInfo[]	错误附加信息。
code	string	错误代码。
details	ErrorDetail[]	错误详细信息。
message	string	错误消息。
target	string	错误目标。

ErrorResponse

Object

错误响应

名称	类型	说明
error	ErrorDetail	错误对象。