Replication Links - List By Database

Layanan:

SQL Database

Versi API:

2021-11-01

Mendapatkan daftar tautan replikasi pada database.

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

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
databaseName	path	True	string	Nama database.
resourceGroupName	path	True	string	Nama grup sumber daya yang berisi sumber daya. Anda dapat memperoleh nilai ini dari Azure Resource Manager API atau portal.
serverName	path	True	string	Nama server.
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	ReplicationLinkListResult	Berhasil mengambil daftar tautan replikasi.
Other Status Codes		Respons Kesalahan: *** 400 ReplicationLinksReplicationLinkNameIsInvalid - Nama tautan replikasi harus menjadi panduan yang valid. 400 GeoReplicationDatabaseNotSecondary - Operasi mengharapkan database menjadi target replikasi. 400 LedgerNoDropLink - Replikasi geografis tidak dapat dihentikan karena database mengaktifkan Unggahan Ledger Digest. Nonaktifkan Ledger Digest Uploads dan coba lagi operasi. 404 ResourceNotFound - Sumber daya yang diminta tidak ditemukan. 404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan 404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Contoh

List replication links on server on database.

Permintaan sampel

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default/providers/Microsoft.Sql/servers/sourcesvr/databases/tetha-db/replicationLinks?api-version=2021-11-01

Java

/**
 * Samples for ReplicationLinks ListByDatabase.
 */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ReplicationLinkListByDatabase.json
     */
    /**
     * Sample code: List replication links on server on database.
     * 
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void listReplicationLinksOnServerOnDatabase(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getReplicationLinks().listByDatabase("Default", "sourcesvr",
            "tetha-db", com.azure.core.util.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

Respon sampel

Kode status:

200

{
  "value": [
    {
      "properties": {
        "partnerServer": "testsvr",
        "partnerDatabase": "tetha-db",
        "partnerLocation": "Japan East",
        "role": "Primary",
        "partnerRole": "Secondary",
        "replicationMode": "ASYNC",
        "startTime": "2018-06-21T08:11:46.907Z",
        "percentComplete": 100,
        "replicationState": "CATCH_UP",
        "isTerminationAllowed": true,
        "linkType": "GEO"
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default/providers/Microsoft.Sql/servers/sourcesvr/databases/tetha-db/replicationLinks/fb92de60-eb87-4a58-b250-3362d0cfdf26",
      "name": "fb92de60-eb87-4a58-b250-3362d0cfdf26"
    },
    {
      "properties": {
        "partnerServer": "targetsvr",
        "partnerDatabase": "tetha-db",
        "partnerLocation": "Japan East",
        "role": "Primary",
        "partnerRole": "Secondary",
        "replicationMode": "ASYNC",
        "startTime": "2018-06-21T08:11:34.423Z",
        "percentComplete": 100,
        "replicationState": "CATCH_UP",
        "isTerminationAllowed": true,
        "linkType": "GEO"
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default/providers/Microsoft.Sql/servers/sourcesvr/databases/tetha-db/replicationLinks/6ad1eefc-18a2-4fcb-94f3-4b654ba788d7",
      "name": "6ad1eefc-18a2-4fcb-94f3-4b654ba788d7"
    }
  ]
}

Definisi

Nama	Deskripsi
ReplicationLink	Tautan replikasi.
ReplicationLinkListResult	Daftar tautan replikasi.
ReplicationLinkType	Jenis tautan (GEO, NAMED, STANDBY).
ReplicationRole	Peran replikasi lokal.
ReplicationState	Status replikasi (PENDING, SEEDING, CATCHUP, SUSPENDED).

ReplicationLink

Tautan replikasi.

Nama	Jenis	Deskripsi
id	string	ID Sumber Daya.
name	string	Nama sumber daya.
properties.isTerminationAllowed	boolean	Apakah pengguna saat ini diizinkan untuk mengakhiri tautan.
properties.linkType	ReplicationLinkType	Jenis tautan (GEO, NAMED, STANDBY).
properties.partnerDatabase	string	Database mitra sumber daya.
properties.partnerLocation	string	Lokasi mitra sumber daya.
properties.partnerRole	ReplicationRole	Peran replikasi mitra.
properties.partnerServer	string	Server mitra sumber daya.
properties.percentComplete	integer	Persentase penyelesaian seeding untuk tautan.
properties.replicationMode	string	Mode replikasi.
properties.replicationState	ReplicationState	Status replikasi (PENDING, SEEDING, CATCHUP, SUSPENDED).
properties.role	ReplicationRole	Peran replikasi lokal.
properties.startTime	string	Waktu saat tautan dibuat.
type	string	Jenis sumber daya

ReplicationLinkListResult

Daftar tautan replikasi.

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

ReplicationLinkType

Jenis tautan (GEO, NAMED, STANDBY).

Nama	Jenis	Deskripsi
GEO	string
NAMED	string
STANDBY	string

ReplicationRole

Peran replikasi lokal.

Nama	Jenis	Deskripsi
Copy	string
NonReadableSecondary	string
Primary	string
Secondary	string
Source	string

ReplicationState

Status replikasi (PENDING, SEEDING, CATCHUP, SUSPENDED).

Nama	Jenis	Deskripsi
CATCH_UP	string
PENDING	string
SEEDING	string
SUSPENDED	string