Get Azure SQL Restore Points

In this article

    You can get a list of all restore points of an Azure SQL restore points available for a restore operation in Veeam Backup for Microsoft Azure.

    Request

    To retrieve a representation of all Azure SQL restore points, send the HTTP GET request to the /restorePoints/sql endpoint.

    HTTP Request

    GET https://<hostname>/api/v3/restorePoints/sql

    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

    DatabaseId

    string

    Returns only restore points of an Azure SQL database with the specified ID. For more information, see Filter Parameters.

    OnlyLatest

    boolean

    Defines whether Veeam Backup for Microsoft Azure must return only the latest restore point.

    DataRetrievalStatuses

    • None
    • Retrieving
    • Retrieved

    Returns only restore points with a specified retrieval status. For more information, see Filter Parameters.

    PointInTime

    string($date-time)

    Date and time of the restore point.

    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 /restorePoints/sql collection. The SqlRestorePointV3 schema is used for the collection representation.

    Get Azure VM Restore Points_2Example

    The following request returns a full list of restore points.

    Request:

    GET https://51.11.247.127/api/v3/restorePoints/sql

     

    Request Header:

    Authorization: Bearer <Access-Token>

     

    Response:

    200

     

    Response Body:

    {

     "offset": 0,

     "limit": 200,

     "totalCount": 13,

     "results": [

       {

         "id": "02b219c6-7e8a-4fc0-a701-6dd0efb4eb65",

         "type": "Incremental",

         "databaseId": "c7f7o8ndjoq36w7azqjotsbn71z9y9s7macyni7jhziehit88b5y",

         "databaseName": "SQL Database 003",

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

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

         "backupSizeBytes": 1616741,

         "gfsFlags": "Daily",

         "backupDestination": "AzureBlob",

         "usn": 124257,

         "dataRetrievalStatus": "None",

         "_embeddedResources": {

           "repositoryName": "SqlRepository"

         },

         "_links": {

           "self": {

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

           }

         }

       },

       {

         "id": "18fb65b4-96d8-4e46-a2bb-e0b40954a9ba",

         "type": "Full",

         "databaseId": "efs1brhjhbjxdgxrd5111a6155b1pq7i5chk6qg6nmhrgx9qs7wy",

         "databaseName": "Dept-35",

         "vbrId": "93878524-ee5a-49fa-874a-acbed9612a79",

         "pointInTime": "2021-08-19T20:10:01.721532Z",

         "backupSizeBytes": 3174832,

         "gfsFlags": "Weekly",

         "jobSessionId": "a90e59c7-6026-40ce-8ca8-f6e06c29f6e8",

         "backupDestination": "AzureBlob",

         "usn": 124236,

         "dataRetrievalStatus": "None",

         "_embeddedResources": {

           "repositoryName": "SqlRepository"

         },

         "_links": {

           "self": {

             "href": "https://51.11.247.127/api/v3/restorePoints/sql/18fb65b4-96d8-4e46-a2bb-e0b40954a9ba?expand=RepositoryName"

           },

           "BackupJob": {

             "href": "https://51.11.247.127/api/v3/jobSessions/a90e59c7-6026-40ce-8ca8-f6e06c29f6e8"

           }

         }

       },

    ...

     ],

     "_links": {

       "self": {

         "href": "https://51.11.247.127/api/v3/restorePoints/sql?onlyLatest=False&expand=RepositoryName&offset=0&limit=200"

       }

     }

    }