Get Azure SQL Restore Point Data

In this article

    You can get data on an Azure SQL restore point with the specified ID.

    Request

    To retrieve information on a specific restore point, send the HTTP GET request to the /restorePoints/sql/{restorePointId} endpoint. {restorePointId} is a system ID assigned to the restore point of an Azure VM in the Veeam Backup for Microsoft Azure REST API.

    HTTP Request

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

    Query Parameters

    To control the amount and order of data in the response, you can use Offset, Limit and the following query parameters:

    Query Parameter

    Value

    Description

    Expand

    • None
    • RepositoryId
    • VbrBackup
    • StorageTier
    • AccountsInfo

    Returns additional data on a restore point.

    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.

    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 a representation of the Azure SQL restore point with the specified ID. The SqlRestorePointV3 schema is used for the resource representation.

    Get Azure VM Restore Point Data_2Example

    The following request returns information on a restore point with the ID 047a1f81-b7fe-457b-90ce-531e465e2d7b.

    Request:

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

     

    Request Header:

    Authorization: Bearer <Access-Token>

     

    Response:

    200

     

    Response Body:

    {

     "id": "047a1f81-b7fe-457b-90ce-531e465e2d7b",

     "type": "Incremental",

     "databaseId": "c7f7o8ndjoq36w7azqjotsbn71z9y9s7macyni7jhziehit88b5y",

     "databaseName": "SqlDatabase",

     "vbrId": "0a9bda7a-0232-4e42-be2f-02491d596054",

     "pointInTime": "2021-09-03T18:20:10Z",

     "backupSizeBytes": 1616741,

     "gfsFlags": "Daily",

     "backupDestination": "AzureBlob",

     "usn": 124257,

     "dataRetrievalStatus": "None",

     "_embeddedResources": {},

     "_links": {

       "self": {

         "href": "https://51.11.247.127/api/v3/restorePoints/sql/02b219c6-7e8a-4fc0-a701-6dd0efb4eb65"

       }

     }

    }