Sync Groups - List Logs
Gets a collection of sync group logs.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/syncGroups/{syncGroupName}/logs?startTime={startTime}&endTime={endTime}&type={type}&api-version=2021-11-01
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/syncGroups/{syncGroupName}/logs?startTime={startTime}&endTime={endTime}&type={type}&continuationToken={continuationToken}&api-version=2021-11-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
database
|
path | True |
string |
The name of the database on which the sync group is hosted. |
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. |
server
|
path | True |
string |
The name of the server. |
subscription
|
path | True |
string |
The subscription ID that identifies an Azure subscription. |
sync
|
path | True |
string |
The name of the sync group. |
api-version
|
query | True |
string |
The API version to use for the request. |
end
|
query | True |
string |
Get logs generated before this time. |
start
|
query | True |
string |
Get logs generated after this time. |
type
|
query | True |
The types of logs to retrieve. |
|
continuation
|
query |
string |
The continuation token for this operation. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
Successfully retrieved sync group logs. |
|
Other Status Codes |
*** Error Responses: ***
|
Examples
Get sync group logs
Sample request
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328/syncGroups/syncgroupcrud-3187/logs?startTime=2017-01-01T00:00:00&endTime=2017-12-31T00:00:00&type=All&api-version=2021-11-01
Sample response
{
"value": [
{
"timestamp": "2017-05-30T07:16:08.25Z",
"type": "Success",
"source": "syncgroupcrud-8475.database.windows.net/hub",
"details": "Schema information obtained successfully.",
"tracingId": "c0480c8e-6269-424e-9404-b00efce0ebae",
"operationStatus": "SchemaRefreshSuccess"
},
{
"timestamp": "2017-05-30T07:03:37.5733333Z",
"type": "Error",
"source": "syncgroupcrud-8475.database.windows.net/member",
"details": "Getting schema information for the database failed with the exception \"Failed to connect to server .\nInner exception: SqlException Error Code: -2146232060 - SqlError Number:53, Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) \nInner exception: The network path was not found\n For more information, provide tracing ID ‘cd3aa28c-0c31-471f-8a77-f1b21c908cbd’ to customer support.\"",
"tracingId": "cd3aa28c-0c31-471f-8a77-f1b21c908cbd",
"operationStatus": "SchemaRefreshFailure"
}
]
}
Definitions
Name | Description |
---|---|
Sync |
A list of sync group log properties. |
Sync |
Properties of an Azure SQL Database sync group log. |
Sync |
Type of the sync group log. |
Sync |
The types of logs to retrieve. |
SyncGroupLogListResult
A list of sync group log properties.
Name | Type | Description |
---|---|---|
nextLink |
string |
Link to retrieve next page of results. |
value |
Array of results. |
SyncGroupLogProperties
Properties of an Azure SQL Database sync group log.
Name | Type | Description |
---|---|---|
details |
string |
Details of the sync group log. |
operationStatus |
string |
OperationStatus of the sync group log. |
source |
string |
Source of the sync group log. |
timestamp |
string |
Timestamp of the sync group log. |
tracingId |
string |
TracingId of the sync group log. |
type |
Type of the sync group log. |
SyncGroupLogType
Type of the sync group log.
Name | Type | Description |
---|---|---|
All |
string |
|
Error |
string |
|
Success |
string |
|
Warning |
string |
SyncGroupsType
The types of logs to retrieve.
Name | Type | Description |
---|---|---|
All |
string |
|
Error |
string |
|
Success |
string |
|
Warning |
string |