Managed Database Restore Details - Get
Gets managed database restore details.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/restoreDetails/Default?api-version=2021-11-01
URI Parameters
| Name | In | Required | Type | Description |
|---|---|---|---|---|
|
database
|
path | True |
string |
The name of the database. |
|
managed
|
path | True |
string |
The name of the managed instance. |
|
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. |
|
restore
|
path | True |
The name of the restore details to retrieve. |
|
|
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 |
Successfully retrieved restore details. |
|
| Other Status Codes |
*** Error Responses: ***
|
Examples
Managed database restore details.
Sample Request
Sample Response
{
"properties": {
"status": "Restoring",
"currentRestoringFileName": "full_0",
"percentCompleted": 0,
"unrestorableFiles": [],
"numberOfFilesDetected": 26,
"lastUploadedFileName": "log2_3",
"lastUploadedFileTime": "2018-06-15T11:38:33Z"
},
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/managedInstance/databases/testdb/restoreDetails/current",
"name": "current",
"type": "Microsoft.Sql/managedInstances/databases/restoreDetails"
}
Definitions
| Name | Description |
|---|---|
|
Managed |
A managed database restore details. |
|
Restore |
The name of the restore details to retrieve. |
ManagedDatabaseRestoreDetailsResult
A managed database restore details.
| Name | Type | Description |
|---|---|---|
| id |
string |
Resource ID. |
| name |
string |
Resource name. |
| properties.blockReason |
string |
The reason why restore is in Blocked state. |
| properties.currentRestoringFileName |
string |
Current restoring file name. |
| properties.lastRestoredFileName |
string |
Last restored file name. |
| properties.lastRestoredFileTime |
string |
Last restored file time. |
| properties.lastUploadedFileName |
string |
Last uploaded file name. |
| properties.lastUploadedFileTime |
string |
Last uploaded file time. |
| properties.numberOfFilesDetected |
integer |
Number of files detected. |
| properties.percentCompleted |
number |
Percent completed. |
| properties.status |
string |
Restore status. |
| properties.unrestorableFiles |
string[] |
List of unrestorable files. |
| type |
string |
Resource type. |
RestoreDetailsName
The name of the restore details to retrieve.
| Name | Type | Description |
|---|---|---|
| Default |
string |