Get Azure SQL Restore Points
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 |
| 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 |
| 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 |
| 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.
Example
The following request returns a full list of restore points.
|