Restore Points

Service:
SQL Database
API Version:
2014-04-01

Gets a list of database restore points.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/restorePoints&api-version={api-version}
With optional parameters: 
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/restorePoints?$expand={$expand}&api-version={api-version}

URI Parameters

Name In Required Type Description
subscriptionId
 path True
  • string

The subscription ID that identifies an Azure subscription.
resourceGroupName
 path True
  • string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName
 path True
  • string

The name of the server.
databaseName
 path True
  • string

The name of the database to get available restore points.
$expand
 query
  • string
A comma separated list of child objects to expand in the response. Possible properties: serviceTierAdvisors, transparentDataEncryption.
api-version
 query True
  • string

The API version to use for the request.

Responses

Name Type Description
200 OK

OK

Examples

Get a database's restore points
Get a data warehouse's restore points

Get a database's restore points

Sample Request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/sqlcrudtest-9007/databases/3481/restorePoints&api-version=2014-04-01

Sample Response

Status code:
200 
{
  "value": [
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/sqlcrudtest-9007/databases/3481/restorepoints/ContinuousRestorePoint",
      "name": "ContinuousRestorePoint",
      "location": "West US",
      "type": "Microsoft.Sql/servers/databases/restorePoints",
      "properties": {
        "restorePointType": "CONTINUOUS",
        "earliestRestoreDate": "2017-06-12T00:00:00.000Z",
        "restorePointCreationDate": null
      }
    }
  ]
}

Get a data warehouse's restore points

Sample Request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/sqlcrudtest-9007/databases/3481/restorePoints&api-version=2014-04-01

Sample Response

Status code:
200 
{
  "value": [
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/9007/databases/3481/restorepoints/131448209670000000",
      "name": "131448209670000000",
      "location": "West US",
      "type": "Microsoft.Sql/servers/databases/restorePoints",
      "properties": {
        "restorePointType": "DISCRETE",
        "earliestRestoreDate": null,
        "restorePointCreationDate": "2017-07-18T03:09:27.000Z"
      }
    },
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/9007/databases/3481/restorepoints/131448353660000000",
      "name": "131448353660000000",
      "location": "West US",
      "type": "Microsoft.Sql/servers/databases/restorePoints",
      "properties": {
        "restorePointType": "DISCRETE",
        "earliestRestoreDate": null,
        "restorePointCreationDate": "2017-07-18T07:09:26.000Z"
      }
    },
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/9007/databases/3481/restorepoints/131448497660000000",
      "name": "131448497660000000",
      "location": "West US",
      "type": "Microsoft.Sql/servers/databases/restorePoints",
      "properties": {
        "restorePointType": "DISCRETE",
        "earliestRestoreDate": null,
        "restorePointCreationDate": "2017-07-18T11:09:26.000Z"
      }
    },
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6730/providers/Microsoft.Sql/servers/9007/databases/3481/restorepoints/131448641650000000",
      "name": "131448641650000000",
      "location": "West US",
      "type": "Microsoft.Sql/servers/databases/restorePoints",
      "properties": {
        "restorePointType": "DISCRETE",
        "earliestRestoreDate": null,
        "restorePointCreationDate": "2017-07-18T15:09:25.000Z"
      }
    }
  ]
}

Definitions

RestorePoint

A database restore point.
RestorePointListResult

A database restore point.

Name Type Description
earliestRestoreDate
  • string
    date-time

Earliest restore time (ISO8601 format). Populated when restorePointType = DISCRETE. Null otherwise.
restorePointCreationDate
  • string
    date-time

Restore point creation time (ISO8601 format). Populated when restorePointType = CONTINUOUS. Null otherwise.
restorePointType
  • enum:
    • DISCRETE
    • CONTINUOUS

The restore point type of the database restore point.
Name Type Description
value

The list of database restore points.