Skip to content
Internal API Catalog
/
Backup and Recovery API
/
API reference
/
v1beta1
/
mssql-database-backups

Backup and Recovery API (1.1.0)

Backup and Recovery API

Download OpenAPI description
backup-recovery-api.json
backup-recovery-api.yaml
Overview
License

HPE End User License Agreement

Languages
Servers
Mock server

https://stage-developer-portal-hpe.redocly.app/_mock/docs/greenlake/services/backup-recovery/public/openapi/backup-recovery-public-v1beta1/backup-recovery-api/

https://us-west.api.greenlake.hpe.com/

https://eu-west.api.greenlake.hpe.com/

https://eu-central.api.greenlake.hpe.com/

https://ap-northeast.api.greenlake.hpe.com/

Protection Store Gateway

Protection Store Gateway APIs

Operations

StoreOnce

StoreOnce APIs

Operations

application-hosts

The Application Hosts API allows the registration and management of Application Hosts.

Operations

data-orchestrators

APIs for managing Data Orchestrator operations.

Operations

datastores

The datastores API allows the data management operations on datastores.

Operations

mssql-database-backups

The MSSQL database backups API allows the creation and management of MSSQL database backups.

Operations

Get information about all MSSQL database backups.

Request

Get information about all MSSQL database backups.

Security
bearer
Path
db-idstringrequired

UUID string uniquely identifying the MSSQL Database

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
Query
offsetinteger

The number of items to skip before starting to collect the result set

limitinteger[ 1 .. 1000 ]

The numbers of items to return

Default 20
filterstring

The filter query parameter is used to filter the set of resources returned in the response. The returned set of resources must match the criteria in the filter query parameter.

A comparision compares a property name to a literal. The comparisons supported are the following:

  • “eq” : Is a property equal to value. Valid for number, boolean and string properties.
  • “gt” : Is a property greater than a value. Valid for number or string timestamp properties.
  • “lt” : Is a property less than a value. Valid for number or string timestamp properties
  • “in” : Is a value in a property (that is an array of strings)

Examples:

  • GET /backup-recovery/v1beta1/mssql-databases/{db-id}/backups?filter="backupType eq CLOUD_BACKUP"

Filters are supported on the following attributes:

  • backupType
  • state
  • status
  • createdByInfo/id
  • createdByInfo/name
  • storageSystemInfo/id
  • storageSystemInfo/type
  • storageSystemInfo/name
  • sourceCopyInfo/id
  • pointInTime
  • verified
  • protectionStoreInfo/id
  • protectionStoreInfo/name
sortstring

A comma separated list of properties to sort by, followed by a direction indicator ("asc" or "desc"). If no direction indicator is specified, the default order is ascending.

selectstring

The select query parameter is used to limit the properties returned with a resource or collection-level GET. Multiple properties can be listed to be returned. The server must only return the set of properties requested by the client. The property “select” is the name of the select query parameter; its value is the list of properties to return separated by commas.

curl -i -X GET \
  https://stage-developer-portal-hpe.redocly.app/_mock/docs/greenlake/services/backup-recovery/public/openapi/backup-recovery-public-v1beta1/backup-recovery-api/backup-recovery/v1beta1/mssql-databases/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4/backups \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

MSSQL database backup list

Bodyapplication/json
itemsArray of objects(MSSQLDatabaseBackup)required
items[].​idstringrequired

UUID string uniquely identifying the backup.

Example: "9b4c14a6-3cd5-4907-97c4-cf44c5b641e4"
items[].​typestringread-onlyrequired

The type of resource.

items[].​associatedDatabasesArray of objects

Details of the databases whose backup is also part of this backup object. On deleting this backup object the backed up data of the associated databases which is part of this backup is also deleted

items[].​backupGranularitystring(backupGranularity)

Applicable only to backup copies. Specifies granularity at which the backup is created. The user can specify whether to create volume based backups or application Change Block Tracking (CBT) based backups.

Enum"VOLUME""VMWARE_CBT"
items[].​backupSetsInfoArray of objects

Information about the associated backupSetInfo. This is an array to handle application backups spanning multiple objects in the device.

items[].​backupTypestring
Enum"BACKUP""CLOUD_BACKUP"
items[].​createdByInfoobject

Information about the user who initiated the workflow that created this backup.

items[].​customerIdstring

The customer application identifier.

items[].​descriptionstring

Brief description about the application backup.

items[].​expiresAtstring(date-time)

Absolute value of time in UTC at which the application backup expires.

items[].​generationinteger(int64)read-only

A monotonically increasing value. This value updates when the resource is updated and can be used as a short way to determine if a resource has changed or which of two different copies of a resource is more up to date.

items[].​lockedUntilstring(date-time)

Absolute value of time in UTC until which the application backup is locked.

Example: "2020-04-03T05:03:08.900Z"
items[].​logBackupInfoobject
items[].​namestring

Name of the application backup.

Example: "Nimble-DB1-snap"
items[].​pointInTimestring(date-time)

Time in UTC at which the application backup was created on the device.

Example: "2020-03-03T05:03:08.902Z"
items[].​protectionStoreInfoobject(CopyPoolInfo)

Information about the protection store where the copy is created.

items[].​resourceUristring

The 'self' reference for this resource.

Example: "/backup-recovery/v1beta1/mssql-databases/{db-id}/backups/{backup-id}"
items[].​scheduleInfoobject

Details about the schedule which created this snapshot.

items[].​sourceCopyInfoobject
items[].​statestring

The current state of the application backup.

Enum"OK""ERROR""CREATING"
Example: "OK"
items[].​stateReasonstring<= 255 characters

Brief reason for the current state of the application backup.

items[].​statusstring

Current status of the application backup.

Enum"OK""ERROR""WARNING"
items[].​storageSystemInfoobject

Information about storage system where backup is created.

items[].​updatedAtstring(date-time)

Time in UTC at which the object was last updated.

countintegerrequired

Number of items in this response.

pageLimitinteger

The numbers of items to return

pageOffsetinteger

The number of items to skip before starting to collect the result set

totalinteger

Total number of documents matching filter criteria.

Response
application/json
{
  "count": 0,
  "items": [
    { … }
  ],
  "pageLimit": 0,
  "pageOffset": 0,
  "total": 0
}

Delete an MSSQL database backup.

Request

Remove an MSSQL database backup.

Security
bearer
Path
db-idstringrequired

UUID string uniquely identifying the MSSQL Database

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
backup-idstringrequired

UUID string uniquely identifying the backup.

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
curl -i -X DELETE \
  https://stage-developer-portal-hpe.redocly.app/_mock/docs/greenlake/services/backup-recovery/public/openapi/backup-recovery-public-v1beta1/backup-recovery-api/backup-recovery/v1beta1/mssql-databases/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4/backups/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4 \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

Accepted

Headers
Locationstring
Bodyapplication/json
object(EmptyResponse)
Response
application/json
{}

Get details of a MSSQL database backup.

Request

Get detailed information for a MSSQL database backup qualified by backup-id.

Security
bearer
Path
db-idstringrequired

UUID string uniquely identifying the MSSQL Database

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
backup-idstringrequired

UUID string uniquely identifying the backup.

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
curl -i -X GET \
  https://stage-developer-portal-hpe.redocly.app/_mock/docs/greenlake/services/backup-recovery/public/openapi/backup-recovery-public-v1beta1/backup-recovery-api/backup-recovery/v1beta1/mssql-databases/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4/backups/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4 \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

Detailed information of a MSSQL database backup

Bodyapplication/json
idstringrequired

UUID string uniquely identifying the backup.

Example: "9b4c14a6-3cd5-4907-97c4-cf44c5b641e4"
typestringread-onlyrequired

The type of resource.

associatedDatabasesArray of objects

Details of the databases whose backup is also part of this backup object. On deleting this backup object the backed up data of the associated databases which is part of this backup is also deleted

backupGranularitystring(backupGranularity)

Applicable only to backup copies. Specifies granularity at which the backup is created. The user can specify whether to create volume based backups or application Change Block Tracking (CBT) based backups.

Enum"VOLUME""VMWARE_CBT"
backupSetsInfoArray of objects

Information about the associated backupSetInfo. This is an array to handle application backups spanning multiple objects in the device.

backupTypestring
Enum"BACKUP""CLOUD_BACKUP"
createdByInfoobject

Information about the user who initiated the workflow that created this backup.

customerIdstring

The customer application identifier.

descriptionstring

Brief description about the application backup.

expiresAtstring(date-time)

Absolute value of time in UTC at which the application backup expires.

generationinteger(int64)read-only

A monotonically increasing value. This value updates when the resource is updated and can be used as a short way to determine if a resource has changed or which of two different copies of a resource is more up to date.

lockedUntilstring(date-time)

Absolute value of time in UTC until which the application backup is locked.

Example: "2020-04-03T05:03:08.900Z"
logBackupInfoobject
namestring

Name of the application backup.

Example: "Nimble-DB1-snap"
pointInTimestring(date-time)

Time in UTC at which the application backup was created on the device.

Example: "2020-03-03T05:03:08.902Z"
protectionStoreInfoobject(CopyPoolInfo)

Information about the protection store where the copy is created.

resourceUristring

The 'self' reference for this resource.

Example: "/backup-recovery/v1beta1/mssql-databases/{db-id}/backups/{backup-id}"
scheduleInfoobject

Details about the schedule which created this snapshot.

sourceCopyInfoobject
statestring

The current state of the application backup.

Enum"OK""ERROR""CREATING"
Example: "OK"
stateReasonstring<= 255 characters

Brief reason for the current state of the application backup.

statusstring

Current status of the application backup.

Enum"OK""ERROR""WARNING"
storageSystemInfoobject

Information about storage system where backup is created.

updatedAtstring(date-time)

Time in UTC at which the object was last updated.

Response
application/json
{
  "associatedDatabases": [
    { … }
  ],
  "backupGranularity": "VOLUME",
  "backupSetsInfo": [
    { … }
  ],
  "backupType": "BACKUP",
  "createdByInfo": {
    "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
    "name": "string"
  },
  "customerId": "string",
  "description": "string",
  "expiresAt": "2019-08-24T14:15:22Z",
  "generation": 0,
  "id": "9b4c14a6-3cd5-4907-97c4-cf44c5b641e4",
  "lockedUntil": "2020-04-03T05:03:08.900Z",
  "logBackupInfo": {
    "lastLogBackupTime": "2020-03-03T06:03:08.902Z",
    "protectionStoreInfo": { … },
    "storageSystemInfo": { … }
  },
  "name": "Nimble-DB1-snap",
  "pointInTime": "2020-03-03T05:03:08.902Z",
  "protectionStoreInfo": {
    "id": "6a38acc7-e470-4ed7-b141-ca9509672dac",
    "name": "string",
    "protectionStoreType": "ON_PREMISES",
    "resourceUri": "/backup-recovery/v1beta1/protection-stores/6a38acc7-e470-4ed7-b141-ca9509672da",
    "type": "backup-recovery/protection-store"
  },
  "resourceUri": "/backup-recovery/v1beta1/mssql-databases/{db-id}/backups/{backup-id}",
  "scheduleInfo": {
    "id": "string",
    "name": "Hourly snapshot schedule",
    "recurrence": "BY_MINUTES"
  },
  "sourceCopyInfo": {
    "id": "d0e48314-730a-11ea-b496-48452098762c",
    "resourceUri": "string",
    "type": "SNAPSHOT"
  },
  "state": "OK",
  "stateReason": "string",
  "status": "OK",
  "storageSystemInfo": {
    "displayName": "atlas-dev-psg1.ind.hpecorp.net",
    "id": "6a38acc7-e470-4ed7-b141-ca9509672dac",
    "resourceUri": "string",
    "type": "PROTECTION_STORE_GATEWAY"
  },
  "type": "string",
  "updatedAt": "2019-08-24T14:15:22Z"
}

Update a MSSQL database backup.

Request

Update attributes for a MSSQL database backup.

Security
bearer
Path
db-idstringrequired

UUID string uniquely identifying the MSSQL Database

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
backup-idstringrequired

UUID string uniquely identifying the snapshot.

Example: 9b4c14a6-3cd5-4907-97c4-cf44c5b641e4
Bodyapplication/merge-patch+jsonrequired
descriptionstring

Brief description about the application backup.

expiresAtstring(date-time)

Absolute value of time in UTC at which the application backup expires.

lockedUntilstring(date-time)

Absolute value of time in UTC until which the application backup is locked.

curl -i -X PATCH \
  https://stage-developer-portal-hpe.redocly.app/_mock/docs/greenlake/services/backup-recovery/public/openapi/backup-recovery-public-v1beta1/backup-recovery-api/backup-recovery/v1beta1/mssql-databases/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4/backups/9b4c14a6-3cd5-4907-97c4-cf44c5b641e4 \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>' \
  -H 'Content-Type: application/merge-patch+json' \
  -d '{}'

Responses

Accepted

Headers
Locationstring
Bodyapplication/json
object(EmptyResponse)
Response
application/json
{}

mssql-database-protection-groups

The MSSQL database Protection Groups API allows management of MSSQL database Protection Groups.

Operations

mssql-database-snapshots

The MSSQL database snapshots API allows the creation and management of MSSQL database snapshots.

Operations

mssql-databases

The MSSQL Databases API allows management of MSSQL databases.

Operations

mssql-instances

The MSSQL Instances API allows management of MSSQL instances.

Operations

protection-jobs

The Protection Jobs API allows the creation and management of Protection Jobs.

Operations

protection-policies

The Protection Policies API allows the creation and management of Protection Policies.

Operations

protection-stores

This API allows the creation and management of Protection Stores that represents the backup target for the copies.

Operations

virtual-machine-protection-groups

The virtual machine Protection Groups API allows the creation and management of virtual machine Protection Groups (Group of Virtual Machines, Datastores or Folder for Protection).

Operations

virtual-machines

The virtual machines API allows the data management operations on virtual machines.

Operations

volume-protection-groups

The Volume Protection Groups API allows the creation and management of Volume Protection Groups (Group of Volumes for Protection).

Operations

datastore-backups

Operations

datastore-snapshots

Operations

virtual-machine-backups

Operations

virtual-machine-snapshots

Operations

volume-protection-group-backups

Operations

volume-protection-group-snapshots

Operations