Restorable Dropped Managed Databases - List By Instance

Service:

SQL Database

API Version:

2021-11-01

Mendapatkan daftar database terkelola yang dihilangkan kembali.

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

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
managedInstanceName	path	True	string	Nama instans terkelola.
resourceGroupName	path	True	string	Nama grup sumber daya yang berisi sumber daya. Anda dapat memperoleh nilai ini dari Azure Resource Manager API atau portal.
subscriptionId	path	True	string	ID langganan yang mengidentifikasi langganan Azure.
api-version	query	True	string	Versi API yang digunakan untuk permintaan.

Respons

Nama	Jenis	Deskripsi
200 OK	RestorableDroppedManagedDatabaseListResult	Berhasil mengambil daftar database yang dihilangkan yang dapat dihilangkan.
Other Status Codes		Respons Kesalahan: *** 404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan 404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Contoh

List restorable dropped databases by managed instances

Sample Request

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Test1/providers/Microsoft.Sql/managedInstances/managedInstance/restorableDroppedDatabases?api-version=2021-11-01

Java

import com.azure.core.util.Context;

/** Samples for RestorableDroppedManagedDatabases ListByInstance. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/
     * RestorableDroppedManagedDatabaseListByManagedInstance.json
     */
    /**
     * Sample code: List restorable dropped databases by managed instances.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void
        listRestorableDroppedDatabasesByManagedInstances(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getRestorableDroppedManagedDatabases().listByInstance("Test1",
            "managedInstance", Context.NONE);
    }
}

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

Sample Response

Status code:

200

{
  "value": [
    {
      "properties": {
        "databaseName": "testdb",
        "creationDate": "2017-05-07T04:41:33.937Z",
        "deletionDate": "2017-05-27T02:49:47.69Z"
      },
      "location": "southeastasia",
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/restorableDroppedDatabases/testdb,131403269876900000",
      "name": "testdb,131403269876900000",
      "type": "Microsoft.Sql/managedInstances/restorableDroppedDatabases"
    },
    {
      "properties": {
        "databaseName": "testdb2",
        "creationDate": "2017-05-07T04:41:33.937Z",
        "deletionDate": "2017-05-27T02:49:47.69Z"
      },
      "location": "southeastasia",
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/restorableDroppedDatabases/testdb2,131403269876900000",
      "name": "testdb2,131403269876900000",
      "type": "Microsoft.Sql/managedInstances/restorableDroppedDatabases"
    }
  ]
}

Definisi

Nama	Deskripsi
RestorableDroppedManagedDatabase	Sumber daya database terkelola yang dihilangkan kembali.
RestorableDroppedManagedDatabaseListResult	Daftar database terkelola yang dihilangkan kembali.

RestorableDroppedManagedDatabase

Sumber daya database terkelola yang dihilangkan kembali.

Nama	Jenis	Deskripsi
id	string	ID Sumber Daya.
location	string	Lokasi sumber daya.
name	string	Nama sumber daya.
properties.creationDate	string	Tanggal pembuatan database (format ISO8601).
properties.databaseName	string	Nama database.
properties.deletionDate	string	Tanggal penghapusan database (format ISO8601).
properties.earliestRestoreDate	string	Tanggal pemulihan paling awal database (format ISO8601).
tags	object	Tag sumber daya.
type	string	Jenis sumber daya

RestorableDroppedManagedDatabaseListResult

Daftar database terkelola yang dihilangkan kembali.

Nama	Jenis	Deskripsi
nextLink	string	Tautan untuk mengambil halaman hasil berikutnya.
value	RestorableDroppedManagedDatabase[]	Array hasil.