Perform Azure SQL Database Restore

In this article

    You can can restore corrupted Azure SQL database to a restore point with the specified ID.

    Request

    To perform a disk restore to a specific Azure SQL restore point, send the HTTP POST request to the /restorePoints/sql/{restorePointId}/restoreDb 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}/restoreDb

    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 perform disk restore operation, use the DatabaseRestoreOptopnsV3 schema to send parameters in the request body.

    {

     "newLocation": {

       "newName": "string",

       "targetServerId": "string",

       "elasticPoolName": "string"

     },

     "serviceAccountId": "string",

     "reason": "string",

     "sqlAccountId": "string"

    }

    Response

    The server returns the following response to the client.

    Response Codes

    A successfully completed operation returns a response code 202 (Accepted).

    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.

    Perform Disk Restore_2Example

    The following request starts the restore operation of the Azure SQL database to the restore point with the 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:

     

    {

     "newLocation": {

       "newName": "SqlFolder",

       "targetServerId": "qhhre6nua6xdz815cwfquniemcx6zhxpd5addqndfzfpt9fztgjo",

       "elasticPoolName": "Container"

     },

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

     "reason": "planned restore",

     "sqlAccountId": "7b94fb30-4fbc-74f3-4f68-a49674fbb833"

    }

     

    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"