This is an archive version of the document. To get the most up-to-date information, see the current version.

Retrieve Azure SQL Restore Point Data

You can retrieve Azure SQL restore point data.

Request

To retrieve restore point data, send the HTTP POST request to the /restorePoints/sql/{restorePointId}/retrieveData endpoint. {restorePointId} is a system ID assigned to the restore point of an Azure SQL database in the Veeam Backup for Microsoft Azure REST API.

HTTP Request

POST https://<hostname>/api/v3/restorePoints/sql/{restorePointId}/retrieveData

Request Headers

The request contains the following headers.

Header

Required

Value

Description

Authorization

Required

Bearer <Access-Token>

Authenticates a client who sends the request to the server. Must contain the access token for the current logon session in the Bearer <Access-Token> format.

Request Body

To retrieve Azure SQL restore point data, use the DataRetrievalOptionsV3 schema to send parameters in the request body.

{

 "dataRetrievalPriority": "Normal",

 "daysToKeep": 0,

 "notifyBeforeExpirationHours": 0,

 "notifyAfterComplete": true

}

Response

The server returns the following response to the client.

Response Codes

A successfully completed operation returns a response code 200 (OK).

Response Headers

The response to this request contains the following headers. The response may also include additional standard HTTP headers.

Header

Value

Description

Content-length

integer

Identifies the length of the response body message, in bytes.

Content-type

  • application/json
  • application/problem+json

Identifies the media type of the response body message.

Response Body

In the response body, Veeam Backup for Microsoft Azure returns the session ID of the restore operation. For the session log details, see JobSessionV3.

Validate Disk Restore_2Example

The following request retrieves data on the restore point with system ID 047a1f81-b7fe-457b-90ce-531e465e2d7b.

Request:

POST https://51.11.247.127/api/v3/restorePoints/sql/047a1f81-b7fe-457b-90ce-531e465e2d7b/restoreDb

 

Request Header:

Authorization: Bearer <Access-Token>

 

Request Body:

{

 "dataRetrievalPriority": "Normal",

 "daysToKeep": 5,

 "notifyBeforeExpirationHours": 2,

 "notifyAfterComplete": true

}

 

Response:

200

 

Response Body:

{

 "id": "324e732d-a03c-4b9c-87a9-539ac825745b",

 "type": "RestoreDisk",

 "localizedType": "RestoreDisk",

 "executionStartTime": "2021-12-01T13:35:31.449Z",

 "executionStopTime": "2021-12-01T13:35:31.449Z",

 "executionDuration": "string",

 "status": "Canceled",

 },

 "restoreJobInfo": {

   "reason": "none",

   "vmId": "3a9a4930-7bbc-4b83-9c68-15d674fbc803",

   "items": [

     {

       "id": "3a9a4930-7bbc-4b83-9c68-15d674fbc803",

       "name": "Default VM",

       "type": "VirtualMachine"

     }

   ]

"_links":{

          "self":{

             "href":"https://51.11.247.127/api/v3/cloudInfrastructure/subscriptions/3a9a4930-7bbc-4b83-9c68-15d674fbc803"

                 },

          "expiringConnection":{

                    "href":"https://51.11.247.127/api/v3/accounts/1"